Copy link to clipboard
Copied
Hello everyone, I'm doing a document to complete by employes for the HR. We have differents questions that employes answer by a the dropdown list of a scale from 1 to 4. We want to calculate the sum of the answer en % at the end of the document. Is this something possible ?
Copy link to clipboard
Copied
Please post the name of the Adobe program you use so a Moderator may move this message to that forum
Copy link to clipboard
Copied
I'm using the Acrobate X Pro
Copy link to clipboard
Copied
Moved to the correct forum.
Copy link to clipboard
Copied
Sure. You can use the built-in Sum option in the Calculate tab of a text field to calculate the total.
Then use another field with the following Simple Field Notation formula to calculate the relative score (let's say the total field is called Total and there are 10 questions):
Total / 40
Edit: Sorry, it needs to be out of 40 if there are 10 questions, not out of 10, of course...
Copy link to clipboard
Copied
As long as the main value, and/or the export value of each item in the dropdown is a number. Then the sum or simplified field option can be used.
Copy link to clipboard
Copied
It is only numbers, but it doesn't work when I want to calculate the sum at the end of my document.
Copy link to clipboard
Copied
Hmm, what does happen?
A couple of possible issues.
1) The numbers are being interpreted as text, so they are not adding properly.
2) There are some non-number in the mix that you are not aware of.
If you have formatting on any of these fields, it may be getting in the way of seeing what's going on. It is a good practice to get everything else on the form working first, then apply formatting. So if there is any formatting on these fields, remove it.
Copy link to clipboard
Copied
When I choose the predefine calculation field I can only select all of nothing. I want to calculate only the total of the dropdown lists and then put it in %. There's 11 dropdown lists that are on a scale from 1 to 4 each, so it's suppose to give a total of 44 points.
Copy link to clipboard
Copied
Mouse cursor on field name and press space bar.
Copy link to clipboard
Copied
For the pre-defined calculation, each of the listed fields has a checkbox next to it. Click on the check box to select an individual field.
Copy link to clipboard
Copied
----