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.
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)