| Wiki Markup |
|---|
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\]))_
\\ |
Page History
Overview
Content Tools