-
kenherr46Asked on March 18, 2021 at 1:06 PM
I am trying to calculate a % of the total cost to increase the amount to be charged to cover processing costs.
In this case, I am trying to multiply the value in the Total Fixed Pledge field by 1.03 to show the Total amount to be charged. I'm using a formula of total fixed pledge * 1.03 but the field only shows 1.03 regardless of the calculated value in Total Fixed Pledge field.
Page URL: https://form.jotform.com/210765239863160 -
Welvin Support Team LeadReplied on March 18, 2021 at 6:27 PM
I think you have already sorted this out. I tested the form, and based on your calculation and conditions, it is now correct.
This is your calculation and the result when you choose Yes if people choose to cover the processing costs.
Please contact us again if we can help in any way.
-
kenherr46Replied on March 19, 2021 at 1:30 AM
I found my issue was that I was using my keyboard to enter numbers and operators in the formula and that doesn't work in some cases. Also, it was easier to use the calculation function on the conditions page.
-
John Support Team LeadReplied on March 19, 2021 at 6:09 AM
Right. When you add numbers into the form calculation widget, it will be treated as TEXTS:
Clicking it (to make it black) will convert the value into numbers.
I can say that using the widget is better than using conditions. When you used conditions for calculation purposes, there's a chance of conflicts especially if you are working on more complex calculation tasks while using the widget automatically calculates every time an event takes place in the form - it doesn't need conditions for it to trigger the calculation.
That might sound subjective but, yes, I think it still depends on the workflow you're trying to achieve.
-
kenherr46Replied on March 19, 2021 at 11:11 AM
I agree about using widgets vs conditions. However, I needed an if/then
statement and conditions met that need.
_________________________
Technology Coordinator
...