Copy link to clipboard
Copied
Hello,
I am working on a PDF project for reviews and have drop downs for each category that is being reviewed. In these drop downs there are 1, 1.5, 2, 2.5, etc until 5. I also have a row labeled NA. I have the average for all of the values of all of the dropdowns at the bottom of the sheet. However when selected "NA" it brings the average down and acts as a 0 for its value. How can I put in a or an equivilant as NA to not be calculated as 0?
Any help would be greatly appreciated.
Copy link to clipboard
Copied
In calculation you use to calculate average, exclude fields that has value "NA".
If you share calculation you are using or your file, maybe we can help you more.
Copy link to clipboard
Copied
I will try that, thank you!
Copy link to clipboard
Copied
The average calculation that I am using is just all of the drop downs that are part of the form.
Copy link to clipboard
Copied
You must associate the export value "zero" with the "N/A" item, and use the export value in your calculation script.
Copy link to clipboard
Copied
It would still be used in calculating average, if I understand OP right they don't want to include fields "N/A" in calculating average.
Copy link to clipboard
Copied
Yes, that is correct. I just need it to not calculate NA as a 0. I need it to not be included in the average calculation at all if it is NA.
Copy link to clipboard
Copied
Sorry, I misunderstood.
I hope you will find the light in these topics:
https://community.adobe.com/t5/acrobat-discussions/calculation-of-the-average-of-fields/m-p/8812802
https://community.adobe.com/t5/acrobat-sdk-discussions/ignoring-zeros-when-averaging/m-p/8866555