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

Adobe Calculation Question

New Here ,
Jan 18, 2023 Jan 18, 2023

Copy link to clipboard

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 4- Advance 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

314

Translate

Translate

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 guidelines
Community Expert ,
Jan 18, 2023 Jan 18, 2023

Copy link to clipboard

Copied

Change the field calculation order.

Votes

Translate

Translate

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 guidelines
New Here ,
Jan 19, 2023 Jan 19, 2023

Copy link to clipboard

Copied

Thank you

Votes

Translate

Translate

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 guidelines
Community Expert ,
Jan 18, 2023 Jan 18, 2023

Copy link to clipboard

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.

Votes

Translate

Translate

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 guidelines
New Here ,
Jan 19, 2023 Jan 19, 2023

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

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 guidelines