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