Adobe Calculation Question

[craigk11536846]

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

[Bernd Alheit]

Change the field calculation order.

[craigk11536846]

Thank you

[Nesa Nurani]

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.

[craigk11536846]

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