This functions provides native support for doing balances, e.g. for onhand inventory or general ledger
balances. CloseBal returns the closing balance – which is the sum of the measure since beginning of time
including “todays” transactions.
Syntax:
SUM(CLOSEBAL(measure,[DateColumnName]))
Note: In case there are no transactions for a specific date the date will be excluded from the output. See
also: OPENBAL.
Example:
SUM(CLOSEBAL(measure,[DateColumnName]))
Comments
Is it possible to round the result? For example if the result is 0.000000000000000000012, I would like to change the value into 0.00. So not only the format but the value.
The reason I need it, is to use the visibility agent.
Hi Jora,
The InMemory ETL script offers a ROUND function: https://community.targit.com/hc/en-us/articles/360017716977-ROUND-number-decimal-places-
You can also round values in the end-user client: https://community.targit.com/hc/en-us/articles/360016972237-Result-modifiers
E.g., in the client you could create a calculation like round(sum(d1, 0, m1);2) - this calculation can also be used directly in a visibility agent.
BR / Ole
Please sign in to leave a comment.