Skip to main content
Lisa Johns
Participant
Apr 23, 2020 9:25 PM UTC
Answered

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

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!!

This topic is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct answer
Community Expert
Apr 23, 2020 9:52 PM UTC

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

View reply

2 replies

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
Apr 23, 2020 9:52 PM UTC

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

Translate
Lisa JohnsAuthor
Participant
Apr 27, 2020 7:29 PM UTC

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

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices