I am trying to do a running total at runtime for being able to dynamically update it on the charts and tables with the condition that if the month-year is greater than the current month-year (fiscalperiod) then the total should be 0.00 thereafter until end of year. Achievable in load script, it is posing some issues in the expression on the charts.
So far, I have an error in the PEEK() for some reason. Any help would be appreciated. Thanks.
=
SUM(IF(NUM(FiscalPeriod) < NUM(Year(TODAY()) & NUM(Month(TODAY()), 00)), (Revenue)/1000)) +
SUM(IF(NUM(FiscalPeriod) < NUM(Year(TODAY()) & NUM(Month(TODAY()), 00)),PEEK('Revenue')/1000))