This functions provides native support for doing balances, e.g. for onhand inventory or general ledger
balances. OPENBAL returns the opening balance – which is the sum of the measure since beginning of time until “yesterday”.
Syntax:
SUM(OPENBAL(measure,[DateColumnName]))
Note: In case there are no transactions for a specific date the date will be excluded from the output.
See also: CLOSEBAL
Example:
SUM(OPENBAL(measure,[DateColumnName]))
Comments
Please sign in to leave a comment.