Maximum Value Constraint by Field

  • Resolved Susp3nc3

    (@susp3nc3)


    3 years, 11 months ago

    Hi, I am trying to do a net income calculation for real estate sales. Each brokerage has a “cap” of a maximum of how much you pay out to the brokerage. So I am taking brokerage split percentage + franchise fee percentage (if any) and multiplying that by gross income and subtracting that all by gross income to get the net. But I want that number to be no more than a certain field total which is the “cap amount” (fieldname7). What is the best route to do this? Any info is greatly appreciated!

    (fieldname19)-SUM((fieldname8+fieldname9)*(fieldname19))

    The page I need help with: [log in to see the link]

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

    (@codepeople)

    3 years, 11 months ago

    Hello @susp3nc3

    Thank you very much for using our plugin.

    In short, you want that this component of the equation SUM((fieldname8+fieldname9)*(fieldname19)) would not be higher than the fieldname7. By the way, the SUM operation, in this case, is unnecessary.

    So, you should use the MIN operation to use the value of the fieldname7 field if the result of the mathematical operation (fieldname8+fieldname9)*fieldname19 is higher than fieldname7.

    The equation can be re-written as follows:

    fieldname19-MIN((fieldname8+fieldname9)*fieldname19, fieldname7)

    Best regards.

    Thread Starter Susp3nc3

    (@susp3nc3)

    3 years, 11 months ago

    Amazing! Thank you! Got the Min operating down.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Maximum Value Constraint by Field’ is closed to new replies.