Skip to main content
Participant
February 1, 2024
Answered

Calculating a weighted average in fillable form acrobat

  • February 1, 2024
  • 1 reply
  • 1037 views

I am trying to create fillable PDFs for people to complete performance evaluations
each metric is measured on a scale 1-5
The first set of metrics are weighted at 70% and the others are valued at 30% of the total


How would I create this form that would allow me to rate each of these at at 1-5 and calculate a combined weighted average at the end? 

Thank you!

 

This topic has been closed for replies.
Correct answer try67

You can create groups of check-boxes for this. Each group should have the same name for all the fields in it, but unique export values, preferably "1" to "5". Then you could use a simple formula to calculate the total.

Say you have five groups that count for 70% and 5 that count for 30%, and they are named Group1 to Group10.

You can then use this formula under the Simple Field Notation part of the Calculate tab of your total field:

 

(0.7 * (Group1 + Group2 + Group3 + Group4 + Group5)) + (0.3 * (Group6 + Group7 + Group8 + Group9 + Group10))

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
February 1, 2024

You can create groups of check-boxes for this. Each group should have the same name for all the fields in it, but unique export values, preferably "1" to "5". Then you could use a simple formula to calculate the total.

Say you have five groups that count for 70% and 5 that count for 30%, and they are named Group1 to Group10.

You can then use this formula under the Simple Field Notation part of the Calculate tab of your total field:

 

(0.7 * (Group1 + Group2 + Group3 + Group4 + Group5)) + (0.3 * (Group6 + Group7 + Group8 + Group9 + Group10))

Participant
February 2, 2024

This was pretty much the answer. Only thing I did differently was divide each group of brackets by the number of metrics in their group, so that I was able to get my average for each. Thank you so much!

try67
Community Expert
Community Expert
February 2, 2024

Yeah, I wasn't 100% sure about my math... Your solution seems to make sense!