Calculating Lift %

[Anonymous]

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

[dan_sullivan · Accepted solution]

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

OR

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

[Anonymous]

Thank you, sir!