max

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

    (@codepeople)

    Hi,

    You simply should modify the equation as follows:

    PREC(MAX(fieldname31+fieldname31*0.10,50),2)

    Best regards.

    Thread Starter kmk2012

    (@kmk2012)

    Thanks! It worked ??

    How do I get it so that is doesn’t show up when the fields are blank? thanks again!

    Plugin Author codepeople

    (@codepeople)

    Hi,

    In this case you should use conditional statements or conditional operations as follows:

    IF(AND(fieldname31,fieldname31),PREC(MAX(fieldname31+fieldname31*0.10,50),2),'')

    Best regards.

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