Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe something like this:
if(Date >= max(Date, 6), avg(Value))
- Marcus
Every advice would earn you some karma points 🙂
Maybe something like this:
if(Date >= max(Date, 6), avg(Value))
- Marcus
I now get the idea! Thank you.