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!
Use the Average option under the Calculate tab of your text field.
I tried that and selected "5" across all six categories and that ended up returning a value of 1.07.
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.)?