Apply Percent to form total

[Cathy McInnis]

I'm trying to apply a percentage (15%) to a fillable form.  It will be added to the total.  Can it be done with 2 fields, or do I need a script?  I know nothing about scripts!  Thank you in advance.

[Nesa Nurani]

Can you explain in more details what you try to achieve?

Why use 2 fields?

[Cathy McInnis]

Because there is a subtotal field, I would need a percent field to apply for the total

[Nesa Nurani]

You will probably need a script.

Is 15% always added to total?

How do you calculate total now?

[Cathy McInnis]

15% is always applied (HST) in Nova Scotia.  I haven't done this before, so I've never calculated this type of field.   Are you able to give me a script to use for the 15%?  Thanks.

[Nesa Nurani]

Sure, I can help you, but you need to tell me how you calculate total (include field names).

It would be easier if you can share your file or screenshot of field names.

[Cathy McInnis]

[Nesa Nurani]

Ok, if you just want to add 15% to subtotal, go to 'Total' field 'Calculate' tab and under 'Simplified field notations' enter this: Subtotal*(1+Percent)

If you didn't format the 'Percent' field as percentage, then use this instead:

Subtotal*(1+0.15)

[Cathy McInnis]

Okay.  Thank you for that.  I'll try that.  I tried the Percent field, but it automatically made it x 100.  l'll let you know if there is any problem.

[Cathy McInnis]

Thank you Nesa!  The script worked without the (1+) and shows just the tax amount.

Have a great long weekend.