Find increment in log table per row

[Remco]

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!

[Mario_De_Felipe]

Try: RangeSum([Trend],-above[Trend])