• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
Exit Search

New Here ,
Jan 18, 2023 Jan 18, 2023

Copied

I'm having a little issue (Excel background but not Adobe) on moderizing some forms.   I'm trying to do the following

Field 1- Dollar amount

Field 2- Dollar amount

Field 3- Dollar amount

Field 5 - Field 3 - Field 4

Total-  Field 1+ Field 2 + Field 5.    (I need field 4 to show for auditing purposes).

In the Total where I Add Field 1 + Field 2 work fine.

The issue states when I add Field 5 in the equation to add to the total. It's working backwards.

Example if I put field 3- field 4 25.00 -25.00 field 5 shows 0.00.

But the total reads field 5 as 25.00

2nd example If I put field 3 - field 4 25.00 - 0.00 field 5 shows 25.00 but the total shows 0.00

Any ideas would be greatly appreciated.

Thanks

TOPICS
Create PDFs , JavaScript , PDF forms

Views

253

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
4 Replies 4
Community Expert ,
Jan 18, 2023 Jan 18, 2023

Copied

Change the field calculation order.

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Jan 19, 2023 Jan 19, 2023

Copied

Thank you

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Jan 18, 2023 Jan 18, 2023

Copied

Just to add to Bernd answer, if you are unfamiliar with calculation order, you can change it by selecting 'Prepare form' tool, then click on 'More' then on 'Set field calculation order' and make sure fields that should calculate first are on top.

So in your example, Field 5 should be above Total on the calculation order list.

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Jan 19, 2023 Jan 19, 2023

Copied

LATEST

Thank you so much.  That worked.  I was not aware of this.