Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi my friend... I have the next expression on the chart table:
=(sum({<[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod)"}, [MonthNumPeriod] = {">= {'1'} <=$(=max(MonthNumPeriod))"}, [MonthPeriod]=>}[AMOUNT]*-1)) +(sum({<[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod-1)"}, [MonthNumPeriod] = {">=$(=max(MonthNumPeriod)+1)"}, [MonthPeriod]=>}[AMOUNT]*-1))
Buy I want the sum of the totals to be monthly for Exemplo:
07-2021 = 28,119,839.16, 06-2021 = 27,362,361.27, 05-2021 = 26,308,362.23 etc...
The data is in a database sql server.