Minimum price

  • Resolved yonisbonaud

    (@yonisbonaud)


    2 years, 10 months ago

    Hello,

    I have parameterized this formula:

    prec((fieldname3*fieldname10)+fieldname7,2)

    but I would like to set the displayed result of this formula to be at least 10 €.
    So, if the result is 6€, the field indicates 10€
    If the result is 11.60, do not change anything.

    Thank you very much

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

    (@codepeople)

    Hello @yonisbonaud

    In this case, you should use the MAX operation to return the maximum value between the mathematical operation result and 10, like:

    PREC(MAX(fieldname3*fieldname10+fieldname7, 10),2)

    Best regards.

    Thread Starter yonisbonaud

    (@yonisbonaud)

    Thank you very much for the fast reply it work, god bless you!
    I spent all my afternoon trying this…!

    Best regards

    Plugin Author codepeople

    (@codepeople)

    It has been a pleasure.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Minimum price’ is closed to new replies.