Fix PDF Dropdown Export Values and Calculation Order in Adobe Acrobat
Question details
Configure PDF dropdown export values and field calculations so numeric totals are calculated correctly.

- Product
- Adobe Acrobat Prepare Form
- Device & OS
- not provided
- Scenario
- A PDF form uses descriptive dropdown labels with numeric export values in calculated fields.
- Observed behavior
- Calculations may produce incorrect results when values are treated as text or fields are calculated in the wrong order.
Open the PDF in Adobe Acrobat and make sure you can edit its form fields using Prepare a form. Identify the dropdown, any fields that receive its value, and the final total field.
Set numeric export values and correct the calculation order
Use this approach when a dropdown displays labels but its selected value must be used in a calculation.
In Adobe Acrobat, open the PDF and select All tools > Prepare a form, or open Prepare Form from the Tools menu.
Double-click the dropdown field, open the Options tab, and assign a numeric export value to each descriptive item. For example, use the label High with an export value of 3.
Open the receiving field's Properties and select the Calculate tab. If you use a custom calculation script, convert the dropdown value with Number(), such as Number(this.getField("Dropdown").value), replacing Dropdown with the actual field name.
In Prepare Form, select More > Set Field Calculation Order. Move fields that receive or calculate dropdown values before the total field, then confirm the order.
Select Preview in Prepare Form and choose several dropdown options. Check that the receiving fields and total update as expected.

Work with PDFs and Office files in WPS Office
WPS Office is a free, lightweight alternative for everyday document and PDF work, with a familiar interface and compatibility that makes moving Office files easier. Use Adobe Acrobat to configure the dropdown export values and calculation order described above.

Frequently Asked Questions
Can a dropdown show a label but calculate with a number?
Yes. In Acrobat's Prepare Form tool, open the dropdown's Properties > Options and give each label a numeric export value.
Why does my total combine values as text?
A custom script may be adding strings instead of numbers. In the field's Properties > Calculate tab, use Number() on each value before adding it.
Where do I change the field calculation order?
In Acrobat's Prepare Form tool, select More > Set Field Calculation Order. Place dependent fields before the total field.
Why does a calculation show NaN?
NaN can result when Number() receives nonnumeric text. Check the dropdown's export values under Properties > Options and verify the field names used in the calculation script.




