7 Replies Latest reply on Dec 2, 2014 11:55 AM by fmpro_novice

    Help with a formula (Revised)



      Help with a formula (Revised)


      I'm trying to find the average of only the last 3 fields (that contain data) for the record showing in this diagram.

      The fields are simply named One, Two, Three, Four, etc. I need the average to evaluate only the last 3 numbers entered. In the example shown, the first 6 numbers would be ignored and the average would only be based on the numbers 8, 5 and 6. Hence, the average of 6.3 showing in the gray box.

      (The average is only showing correctly because I drew this in another program.)