Sum function script not updating field when variables being blank

[RealEventDesigns]

Earlier, I asked how to hide values if the the value=0 and got the correct script to put in.

The script I used for this was:

var amount = Number(this.getField("Qty2").value) * Number(this.getField("UP2").value);

event.value = (amount==0) ? "" : amount;

However, the sum function for the "Subtotal" field is now not updating. I am using the sum function in the calculator tab. Am I suppose to put in a script now or can I still use the sum function? Please see the snapshot below. Thanks!

[try67]

Check the field calculation order. The Subtotal field needs to be calculated after the Amount field(s).

[RealEventDesigns]

Thanks!

I had to manually type in the addition of each field as the sum function doesn't do it in the correct order.

Thanks for all your help!

[try67]

That means you didn't solve the problem I pointed out...

[RealEventDesigns]

Sorry, I'm new to this so I don't have much experience. Can you explain what you mean?

[Thom Parker]

In the "Prepare form" mode in Acrobat there is a drop menu on the far left panel with an entry for setting the calculation order. You need to check this and make sure the "SubTotal" field is at the bottom of the list.

[RealEventDesigns]

Got it thank you

[Thom Parker]

Sorry, far right panel.