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]))

  • No labels