PDF Editing Issues

Fix PDF Dropdown Export Values and Calculation Order in Adobe Acrobat

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Configure PDF dropdown export values and field calculations so numeric totals are calculated correctly.

Fix PDF Dropdown Export Values and Calculation Order in Adobe Acrobat
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the form editor

In Adobe Acrobat, open the PDF and select All tools > Prepare a form, or open Prepare Form from the Tools menu.

2
Set dropdown export values

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.

3
Convert values in calculations

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.

4
Set the calculation order

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.

5
Test the form

Select Preview in Prepare Form and choose several dropdown options. Check that the receiving fields and total update as expected.

Set numeric export values and correct the calculation order
Check field names and values: Custom scripts must use the exact form field names. Number() returns NaN for nonnumeric text, so check that each export value is numeric.
Free Microsoft Office alternative

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.

Open PDFs alongside other documents in one applicationWork with Microsoft Office formats, including DOCX and XLSXUse a familiar interface for everyday document tasksAccess a free, lightweight Office alternative
microsoft office alternative - wps office

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.