Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I currently have growth rate calculated as below
Revenue: Sum(Revenue)
Growth Rate: (Sum(Revenue)-Above(Sum(Revenue)))/Above(Sum(Revenue))
With this the 1st record is blank/null/NA.
Is there anyway to calculate the growth rate of 1st record.
Note: My selection on Year filter is from 2017 - 2020. If i select an additional year as 2016, it is showing 2015 rate % blank.
Thanks
Satish
You can simplify the equation and use this
Sum(Revenue)/Above(Sum({<Year>}Revenue)) - 1
Try this
(Sum(Revenue)-Above(Sum({<Year>}Revenue)))/Above(Sum({<Year>}Revenue))
You can simplify the equation and use this
Sum(Revenue)/Above(Sum({<Year>}Revenue)) - 1