Find increment in log table per row

Remco — Tue, 06 Dec 2022 16:42:54 GMT

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!

Re: Find increment in log table per row

Mario_De_Felipe — Wed, 14 Dec 2022 07:21:24 GMT

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

topic Find increment in log table per row in App Development

Find increment in log table per row

Re: Find increment in log table per row