formula help

  • Resolved olsbor

    (@borgeolsen)


    5 years, 4 months ago

    I have one input field where users will fill in the gross tonnage (GT) of a ship, and then be presented for the total to pay.

    I have in total 5 result fields based on the input.

    4 results showing what to pay for different services and one last that sums all fields and gives a total to pay.

    My problem is that when a ship has low GT the minimum sum to pay for some of the services is not met.

    How can I edit these fields so they will display a set minimum number instead of the low value based on the formula.

    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)

    5 years, 4 months ago

    Hello @borgeolsen,

    In this case, you should use the “MAX” operation, the returns the maximum value between its parameters.

    I’ll try to describe the process with an example. Assuming your current equation is fieldname1*fieldname2 but you want to charge a minimum of 100. In this case the equation should be edited as follows:

    
MAX(fieldname1*fieldname2, 100)

    and that’s all.
    Best regards.

    Thread Starter olsbor

    (@borgeolsen)

    5 years, 3 months ago

    Thank you! Worked perfect

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘formula help’ is closed to new replies.