Skip to main content
gregs50739865
Participating Frequently
July 29, 2019
Question

Calculated field sum of check boxes

  • July 29, 2019
  • 1 reply
  • 576 views

Hello,

I am trying to create an employee evaluation form. I'd like the calculated field to be the sum of the check boxes then divided by the total number of categories (6). Each

check box has the appropriate export value according to the rating (1, 2, 3, 4, 5).

So if an employee was rated all 5s across the 6 categories they would average out at a 5. (5 rating x 6 categories / 6 categories).

Any help on how to accomplish this would be appreciated.

Thanks in advance!

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
July 29, 2019

Use the Average option under the Calculate tab of your text field.

gregs50739865
Participating Frequently
July 30, 2019

HI Try67,

I tried that and selected "5" across all six categories and that ended up returning a value of 1.07.

try67
Community Expert
Community Expert
July 30, 2019

I'll need to see the file to be able to help you further with this. Can you share it with us (via Dropbox, Google Drive, Adobe DC, etc.)?