minimum numerical value from calculated field

  • Resolved Francis

    (@emolotel)


    5 years, 11 months ago

    Hello
    can I have a minimum value and a maximum value in a numeric field from a calculated field value?

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @emolotel

    You simply should use the MAX and MIN operations. For example, assuming you have the equation: fieldname1+fieldname2, but you want the result won’t be lesser than 10 or greater than 100, the equation can be edited as follows:

    MAX(MIN(fieldname1+fieldname2, 100), 10)

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘minimum numerical value from calculated field’ is closed to new replies.