Skip to main content
Known Participant
March 3, 2023
Question

Calculation

  • March 3, 2023
  • 2 replies
  • 3124 views

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?

 

 

 

This topic has been closed for replies.

2 replies

Bernd Alheit
Community Expert
Community Expert
March 3, 2023

Change the field calculation order.

Known Participant
March 3, 2023

To what?  Why does that matter?

Bernd Alheit
Community Expert
Community Expert
March 3, 2023

Put the total field at the end of the order.

Nesa Nurani
Community Expert
Community Expert
March 3, 2023

Did you use scripts or built in calculations?

Can you share file with us?

Known Participant
March 3, 2023

Yes, provide me with an email.