CLOSEBALWITHZEROES (measure, [DateColumnName])

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]))
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.