Get 6 last values average in front end

[MindaugasBacius]

Hello,

In the front end I have a table like this:

The expression: (Sum(Value1) + Sum(Value2))/ Sum(Value3)

The customer wishes to get a table that shows the last 6 values average for each Supplier:

The result depends on the Date selections - like supplier c there is only one value and the result is calculated from only one value. But with d supplier, there are more than 6 values. In this case, only the last 6 values should figure while calculating average.

All the calculations have to be made in front end.

Thank you!

[MindaugasBacius]

Every advice would earn you some karma points 🙂

[marcus_sommer · Accepted solution]

Maybe something like this:

if(Date >= max(Date, 6), avg(Value))

- Marcus

[MindaugasBacius]

I now get the idea! Thank you.