rounding

[msbask99]

We have a form that multiplies a purchase price by a sales tax and surcharge rate, then adds the three numbers together.

In the example attached, the actual product of the purchase price times the sales tax is $598.104; and the product of the purchase price times the surcharge is $24.921. When the numbers are added, the total is $17,237.03 but it should be $17,237.02.

Can anyone help with how to round both the sales tax and surcharge, so that the total will be correct?

test-math.pdf

[Ovg]

change actions to:

Sales Tax (3.6%)

Code: Select all

event.value = (Number(this.getField("purchasePrice").valueAsString) * 0.036).toFixed(2);

Surcharge (0.15%)

Code: Select all

event.value =(Number(this.getField("purchasePrice").valueAsString) * 0.0015).toFixed(2);

test-math.pdf

[Tracker Supp-Stefan]

Hello Ovg,

Many thanks for the suggestions!

@msbask99 - please do let us know if the above helps!

Kind regards,
Stefan

[msbask99]

I can't thank you enough. This works perfectly. Much appreciated!

[Ovg]

2msbask99

, You're welcome!

[Radi - Tracker Supp]