Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that has many lines with amount an amount field.
I need to average the last three lines on each line.
Example:
Line Amount Average
1 100 0
2 200 0
3 300 200.00
4 33 177.66
6 49 127.33
7 74 52.00
Try
=rangeavg( above( sum(Amount), 0, 3))
as Average expression. Lines should be sorted ascending in your chart.
Hope this helps,
Stefan
Try
=rangeavg( above( sum(Amount), 0, 3))
as Average expression. Lines should be sorted ascending in your chart.
Hope this helps,
Stefan
Hi,
Please check attached file for solution.
Hope it helps you.
Regards,
Jagan.