# Form calculation is returning the formula

• alexmichaelbarker
Asked on February 01, 2021 at 03:17 PM

hello

I'm trying to create a salary comparison calculator for a popular blog.

I can't seem to figure out the calculator for my form

Example:

1 - place salary here

2 - formula: (place salary here) / \$125,024 %

but when I preview the form, it gives me this as the answer:

140000/125024%

it was once working properly, but now the answer just gives the formula.

link to form:

https://form.jotform.com/210315901459047

However, another problem occurs when the 1 answer is less than the \$125,024, as it no longer portrays a comparison percentage, but a percentage of the total

example:

\$80000/\$125,024 = 64%

instead, I want it to be 36% lower than the average

• Lorenz_A
Answered on February 01, 2021 at 09:30 PM

Greetings,

but when I preview the form, it gives me this as the answer:140000/125024%

Upon checking your form, it returns the formula because you have the division operator set as a string.

See the image below.

Kindly click the division operator and make sure it is not set to string.

However, another problem occurs when the 1 answer is less than the \$125,024, as it no longer portrays a comparison percentage, but a percentage of the total.

I'm quite not sure if that's an issue. I tested your inputs using a device calculator (\$80000/\$125,024) and the result is just the same (64%).

Can you please elaborate more?

We will wait for your response.

• claire
Answered on February 02, 2021 at 03:01 AM

I cloned your form, and I tested it on my end. Since the parentheses you use in your Form Calculation widget appear as String, your answers come in parentheses. Kindly recommend you delete the parentheses from your widget, then click the % icon to set it String instead of Number. I prepared a screencast for you from my cloned form.

Please give it a try and let us know how it goes. We will wait for your response.

• alexmichaelbarker
Answered on February 02, 2021 at 08:46 AM

thank you;

I changed your formula and received this result for

140000

and for 100,000

this is not the result I want.

How can I change the formula to represent the change in percentage?

140,000/\$125,024 (%)- 1= 12%

100,000/\$125,024 (%) -1 = -20%

unfortunately, these are the results I received

140000

100000

so then I tried,

but then I got an incorrect answer. I wanted it to be 11.9%

how do I make a formula that works?

• Gaetan_B
Answered on February 02, 2021 at 09:58 AM

Hello,

Thank you for the additional details.

Could you make your Calculation look exactly like the following:

Hope this helps.

Do not hesitate to reach out if you need further assistance

• alexmichaelbarker
Answered on February 04, 2021 at 08:41 AM

thank you all; this fixed my formula