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. Compared to CLOSEBAL, CLOSEBALWITHZEROES will add additional rows to the rowset if there are missing entries derived from the date being used.
Syntax:
SUM(CLOSEBALWITHZEROES(measure,[DateColumnName]))
Comments
Please sign in to leave a comment.