AnsweredAssumed Answered

Calculating an average

Question asked by spencer123 on Apr 30, 2018
Latest reply on May 2, 2018 by TSGal

What is the best way to calculate the average of a field in multiple records if I want the average to be reflected only for the fields that contain a value?  This average would be returned in a specified field just for this purpose.

 

Example:

Record 1: Field 1 = No Data

Record 2: Field 1 = 1

Record 3: Field 1 = 3

Record 4: Field 1 = No Data

Record 5: Field 1 = 2

 

Returned Average of Field 1 = 2

(*Currently I am receiving returned calculation of what would be 4.4 in this example)

Outcomes