Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
Check the field calculation order. The Subtotal field needs to be calculated after the Amount field(s).
Copy link to clipboard
Copied
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!
Copy link to clipboard
Copied
That means you didn't solve the problem I pointed out...
Copy link to clipboard
Copied
Sorry, I'm new to this so I don't have much experience. Can you explain what you mean?
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
Got it thank you
Copy link to clipboard
Copied
Sorry, far right panel.