Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Thank you, sir!