Corey24304605qet7

New Participant

Question

Drop Down and Average Calculations

Forum|Forum|3 years ago
May 3, 2022
3 replies
861 views

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.

This topic has been closed for replies.

Community Expert

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

Acrobate du PDF, InDesigner et Photoshopographe

Community Expert

You must associate the export value "zero" with the "N/A" item, and use the export value in your calculation script.

Acrobate du PDF, InDesigner et Photoshopographe

Community Expert

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.

Corey24304605qet7Author

New Participant

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.

Community Expert

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.

Corey24304605qet7Author

New Participant

I will try that, thank you!

Corey24304605qet7Author

New Participant

The average calculation that I am using is just all of the drop downs that are part of the form.