Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have this nicely working, the logaritmic trend based on actual values. The trend is calculated as following:
(linest_m(total <COUNTRYCODE, FUELTYPE> aggr(SUM(AVGPERF * NUMUNITS) / SUM(NUMUNITS),COUNTRYCODE, FUELTYPE, STEP),log(STEP)) * Log(STEP))
+ linest_b(total <COUNTRYCODE, FUELTYPE> aggr(SUM(AVGPERF * NUMUNITS) / SUM(NUMUNITS),COUNTRYCODE, FUELTYPE, STEP),log(STEP))
Where STEP is related to the year. But now I am searching for the yearly increment of the trend, see screenshot as example, what I need is the output as in column 'Increment'.
It must be in the expression, not in the load statement. In Excel it is just taking the value from a year minus the value of the previous year. I can easily get the cumulative increment but I need the yearly increment. Any idea how to get this?
Thanks!
Try: RangeSum([Trend],-above[Trend])