4 Replies Latest reply: Oct 16, 2012 3:29 PM by Brian Garside RSS

    Need help with cumulative inflation table...

      I have two base column expressions that I need to project out with a defualt 1.02 inflation rate and have it cumulatively go across each year.




      This one remains untouched

      Sum({<[Cost_Type]={'Revenue'}>} Cost_Value)


      This one will be cumulative

      Sum({<[Cost_Type]={'Cost'}>} Cost_Value * %Inflation)


      Im trying to replicate the excel table as attached.