% Change for 1st record

[satishkurra]

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

[sunny_talwar]

Try this

(Sum(Revenue)-Above(Sum({<Year>}Revenue)))/Above(Sum({<Year>}Revenue))

[sunny_talwar · Accepted solution]

You can simplify the equation and use this

Sum(Revenue)/Above(Sum({<Year>}Revenue)) - 1