### Title

Calculating average while excluding specific fields

### Post

Hi all,

I'm working on a customer survey database/layout. The possible scores for each question are 1 - 5, however, if a question is not relevant to a specific customer then the surveyer enters a 0 for that question.

I would like to calculate an average score, taking into account that questions with a score of 0 should not be included in the average (including the question in the denominator will screw up the average). What calculation logic would I use to exclude the '0's from the count?

Thanks!

-Ryan

Make that score an empty field instead of a zero and an Average summary field will ignore that value.

If you want to keep the zero, define a calculation field such as If ( Response ≠ 0 ; Response ; "" )

Then an average of this calculation field will omit the 0 values.