Equation Result Cannot Be More than 40%

  • Resolved smpvdemkmev

    (@smpvdemkmev)


    3 years, 2 months ago

    Hello, I’m trying to create an equation where the result cannot be more than 40%. It’s a basic subtraction function (fieldname64-fieldname71), but the result can’t be more than 40% of fieldname64.

    I’m using the following equation: MIN(0.4*fieldname64,(fieldname64-fieldname71))

    It makes the result 40% of fieldname64 every time.

    Instead I need it to display the summation, UNLESS the summation is more than 40% of fieldname64. If the summation is more than 40% of fieldname64, I need it to be capped at 40% of fieldname64.

    Thank you for any help you can provide.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @smpvdemkmev

    Your equation is correct. If the maximum value allowed is 40% of the fieldname64 field, you must use the MIN operation as you did. The equation would be:

    MIN(0.4*fieldname64,(fieldname64-fieldname71))

    Please, let me know the values of the fields fieldname64 and fieldname71 you are using for testing.

    Best regards.

    Thread Starter smpvdemkmev

    (@smpvdemkmev)

    Thank you…

    Fieldname64 is the total project cost.
    Fieldname71 is the equity from the borrower.

    So, the fieldname with this equation, Fieldname18, is the sum of total project costs, minus the borrower’s equity. However, the sum can be up to, but not more than, 40% of the total project cost, or Fieldname64.

    As the equation is now, it’s not changing if I change the value of the borrower’s equity amount (Fieldname71). It keeps it at 40% all the time.

    Plugin Author codepeople

    (@codepeople)

    Hello @smpvdemkmev

    If fieldname64-fieldname71 is over than 0.4*fieldname64, the equation’s result will always be 0.4*fieldname64

    Please, send me the link to the form, and indicate the values you are entering for testing. I need to see the equation in action with the values you are entering.

    Best regards.

    Thread Starter smpvdemkmev

    (@smpvdemkmev)

    https://www.growthcorp.com/?cff-form=15

    The values I’m entering are:

    Appraised value: $3,200,000
    Existing Debt: $1,988,348
    Current Monthly Payment: $18,212

    When you scroll down, underneath “Sourece of Funds”, the CDC/SBA portion is $1,280,000. However, it should change if the amount of existing debt is changed. And the bank portion underneath, should be the sum of total project cost – equity – CDC/SBA.

    Plugin Author codepeople

    (@codepeople)

    Hello @smpvdemkmev

    I recommend you check the equations in your form.

    The value of your fieldname64 is calculated by fieldname15+fieldname54+fieldname63

    And the value of the fieldname71 field, SUM(fieldname15)

    So, if you evaluate these operations manually, and the equation MIN(0.4*fieldname64,(fieldname64-fieldname71))

    You will see the 0.4*fieldname64 component is lower than (fieldname64-fieldname71)

    Best regards.

    Thread Starter smpvdemkmev

    (@smpvdemkmev)

    I figured out where my error was. Thank you for the help!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Equation Result Cannot Be More than 40%’ is closed to new replies.