1 Reply Latest reply on Jan 8, 2013 1:03 AM by try67

    field average calculation


      I need to calculate the average of multiple fields. How can I make it so that empty fields don't count as '0's? I only want the average of fields with actual values in them. When I use the preset formula in the calculation tab of the field properties menu it counts all empty fields as '0' which completely messes up the average.