Line averages

[#1]

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   

[swuehl · Accepted solution]

Try

=rangeavg( above( sum(Amount), 0, 3))

as Average expression. Lines should be sorted ascending in your chart.

Hope this helps,

Stefan

[jagan]

Hi,

Please check attached file for solution.

Hope it helps you.

Regards,

Jagan.