0 Replies Latest reply: Jul 7, 2009 9:40 PM by Amirali Vastani RSS

    Partial Accumulation not Full

    Amirali Vastani

      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))