Calculating a percentage based upon the value in another field

  • Profile Image
    kenherr46
    Asked on March 18, 2021 at 01: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.

  • Profile Image
    Welvin
    Answered on March 18, 2021 at 06: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_

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

    1616106397_6053d39d7ce01_

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

  • Profile Image
    kenherr46
    Answered on March 19, 2021 at 01: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.

  • Profile Image
    JohnRex
    Answered on March 19, 2021 at 06:09 AM

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

    1616148185_605476d97e391_formcaa.gif

    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.

  • Profile Image
    kenherr46
    Answered 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


    ...