Skip to main content
L
Lisa Johns
Participant
April 23, 2020
Answered

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

  • April 23, 2020
  • 1 reply
  • 1145 views

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 has been closed for replies.
Correct answer try67

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

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
April 23, 2020

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

L
Lisa JohnsAuthor
Participant
April 27, 2020

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

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