Sales tax automatically calculated from the Subtotal that is manually entered in fillable field

Question

Having trouble figuring out how to get the "Tax Total" to calculate from the "Subtotal" and "Tax" fields when a number is entered into the "Tax" field. Using Adobe Acrobat Pro DC

Beemonkie · Accepted Answer

Thank you so much for the input! After some research in past posts and messing around, this is what I did in the "simplified field notation" and it seems to work. SUBTOTAL*(TAX/100)

Now I need to figure out how to do another calculation. Will create a new post for that.

Thank you!

ls_rbls · Answer

++Adding to the discussion,

You can use a custom calculated script like shown below or better:

var subtotal = this.getField("SUBTOTAL").value;
var tax = this.getField("TAX").value / 100;

event.value = (subtotal * tax) + subtotal;

I placed this calculating event in the "Tax Total" field and additionally formatted all fields as Number using the built-in "Format" feature.

I also noticed that your form offers bulk discounts based on the purchased amount.

In addition to calculating the proper formula that adds the true state sales tax of California to the sum of all item costs in the "SUBTOTAL" field, if you were also asking to see if bulk discounts can be done automatically in the "Total Tax" field with a script, then use something like this (or better):

var subtotal = this.getField("SUBTOTAL").value;
var tax = this.getField("TAX").value / 100;

if (subtotal <= 4999) {

event.value = (subtotal * tax) + (subtotal - (subtotal * .05));

} else {

if (subtotal >= 5000) {

event.value = (subtotal * tax) + (subtotal - (subtotal * .10));

 }
}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded