2 Replies Latest reply: Apr 11, 2012 10:51 AM by jagan mohan rao appala RSS

    Line averages

      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