2 Replies Latest reply: Jul 11, 2017 4:37 PM by harlow hunt RSS

    Calculating Lift %

    harlow hunt

      Hello,

       

      I'm struggling to calculate the percentage 'lift' (2017 sales - 2016 sales) / 2016 sales.

       

      I have used the following expression and it will not work.  It will only return the 2017 sales instead of the 'lift.'

       

      Sum({$<Year={'2017'}>} [Sales Amount])-Sum({$<Year={'2016'}>} [Sales Amount]) / Sum({$<Year={'2016'}>} [Sales Amount])

       

      Any help would be appreciated.

       

       

       

       

      RH