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

    Calculating Lift %

    harlow hunt



      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.