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.

       

      %Inflation=1.02

       

      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.