Calculation

[jennifer28461489ef3d]

I hope I can explain this clearly.  Column A is quantity, Column B is price, and Column C is the total for the quantity*price.  Field A is the total of all entries in Column C.  When testing each field I put a quantity in each box then I removed these quantites.  However, my Total in Field A is not resetting back to zero even though all the amounts in Column A (price) and Column C (total) are zero.  How do I get the Total field to reset (the spot that shows $63.00) to zero if all entries are blank?

[Nesa Nurani]

Did you use scripts or built in calculations?

Can you share file with us?

[jennifer28461489ef3d]

Yes, provide me with an email.

[jennifer28461489ef3d]

For that field I used Value is + with Total1, Total10, Total11, Total12, Total13, Total14, Total15, Total16, Total17, Total18, Total19, Total2, Total20, Total21, Total22, Total23, Total24, Total25, Total26, Total27, Total28, Total29, Total3, Total30, Total31, Total32, Total33, Total34, Total35, Total36, Total37, Total38, Total4, Total5, Total6, Total7, Total8, Total9

[Bernd Alheit]

Change the field calculation order.

[jennifer28461489ef3d]

To what?  Why does that matter?

[Bernd Alheit]

Put the total field at the end of the order.

[jennifer28461489ef3d]

I am not understanding.  Can you provide an example of what it should look like?

[Bernd Alheit]

At Prepare Form use the dropdown More at the right side. There you can set the calculation order.

[jennifer28461489ef3d]

Thank you.

[try67]

In PDF files (unlike in Excel, for example) the order in which fields are calculated is not automatic. It's determined by a list. So if you have field C which is A+B and field D which is C*2, for example, you have to make sure that D is calculated after C (meaning it appears lower than it in the list), or the results will always be "delayed" by one step, and therefore incorrect.