3 Replies Latest reply on Mar 18, 2014 11:07 AM by Magus069

# Scripting & Applying Set Percentage in Javascript

I need to script a set percentage to an existing calculated total field in order to show a new field total with the set percentage applied. Total is already calculated in the form, but I'm not sure how to plug in the 2.25% to calculate for a final total.

Example:

Total ____

Final Total ____ (new field with 2.25 percentage applied)

• ###### 1. Re: Scripting & Applying Set Percentage in Javascript

To use a percentage in a total use these algorithm

Total * 1.0225 = Final Total

for 2.25%

1.0225 = (2.25 / 100) +1

to remove a percentage

1 - (2.25 / 100) = 0.9775

to know a percentage of

2.25 / 100

• ###### 2. Re: Scripting & Applying Set Percentage in Javascript

Robert,

Great – thanks! I did figure that out (eventually), but now have the issue of the Permit Fee field showing \$0.26 when it should just show \$0.00 until the Number field is filled in and the amount is calculated. Can you help? The error screen says that it doesn’t like the last equal sign. I’m at a loss…

TopmostSubform.Page1.Cell[10].Permit_Fee::calculate - (FormCalc, client)

Permit_Fee.rawValue = (4000.00Cell[8].Number + 0.25)1.0225

If(Number.isNull | Permit_Fee = “”)

Thanks!

Noemi Harvell

• ###### 3. Re: Scripting & Applying Set Percentage in Javascript

Because you are using FormCalc it has different operators for statements...

You can look over the FormCalc User Reference Documentation to understand the language

Your If statement would look something like this

if (Number.isNull | Permit_Fee eq "")