Drop Down and Average Calculations

[Corey24304605qet7]

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. 

[Nesa Nurani]

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.

[Corey24304605qet7]

I will try that, thank you!

[Corey24304605qet7]

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

[JR Boulay]

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

[Nesa Nurani]

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.

[Corey24304605qet7]

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.

[JR Boulay]

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