-
alexmichaelbarkerAsked on February 1, 2021 at 3: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
Page URL: https://form.jotform.com/210315901459047 -
Lorenz JotForm SupportReplied on February 1, 2021 at 9: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.
-
alexmichaelbarkerReplied on February 1, 2021 at 10:44 PM
I deselected the division, but now my answers simply come in parenthesis, and without a percentage
Here is the calculation I want:
Examples:
$140,000/ $125,024 = 11.9% (higher than average)
$100,000/$125,024 = -20% (lower than average)
I do not understand how to create a calculation that will give me this result.
-
claireReplied on February 2, 2021 at 3: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.
-
alexmichaelbarkerReplied on February 2, 2021 at 8: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_BReplied on February 2, 2021 at 9: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
-
alexmichaelbarkerReplied on February 4, 2021 at 8:41 AM
thank you all; this fixed my formula