Need help calculating an "average" field when N/A is selected

[Lisa_in_CommTeam]

Hello...

I'm working on an evaluation form that has 5 "scores" to be added and then averaged. Each score could be 1, 1.5, 2, 2.5, 3 or N/A. Getting the total score is no problem...got that. BUT for the "average" field (for example), if N/A is selected for 2 of the 5 scores, the "average" function is still using 5 as a denominator instead of 3. How do you get the calculation to ignore "N/A" entries for the "average" field? PLEASE help!!!! I can attach the form if needed...

Many thanks!!

[try67 · Accepted solution]

You need to use a script to do it. I've posted code that does it multiple times on these forums. Try searching for "calcAverage".

[Lisa_in_CommTeam]

Thanks for the "search term"!! Got it to work perfectly!!!