Versions Compared

Old Version 4

changes.mady.by.user Former - Dennis de Gier [X]

Saved on

compared with

New Version 5

changes.mady.by.user Former - Dennis de Gier [X]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Wiki Markup
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\]))_
\\