Calculating a percentage based upon the value in another field

  • kenherr46
    Asked 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.

  • Welvin Support Team Lead
    Replied 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.

    1616106350 6053d36eabc94  Screenshot 10

    This is your calculation and the result when you choose Yes if people choose to cover the processing costs.

    1616106397 6053d39d7ce01  Screenshot 21

    Please contact us again if we can help in any way.

  • kenherr46
    Replied 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 Lead
    Replied on March 19, 2021 at 6:09 AM

    Right. When you add numbers into the form calculation widget, it will be treated as TEXTS:

    1616148185 605476d97e391 formcaa Screenshot 10

    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.

  • kenherr46
    Replied 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


    ...