Hide minimum value calculated field

  • Resolved Alwin

    (@wp-opti)


    6 years, 2 months ago

    Can you please take a look at:
    https://loeka.optiion.nl/canvas/

    – check the button called “Canvas compleet”

    Now you see a price value of 34.00 and that is because I used this Equation for the Calculated field “Prijs Canvas compleet”.
    PREC(fieldname17*2.32+34.00,2)

    I don’t like the fact that the minumum price of 34.00 is displayed while there is no input in the fields called “Korte zijde foto in cm” and “Lange zijde foto in cm”.

    It would be nice if the field “Prijs Canvas compleet” would show a value of 0.00 and only shows the calculated price when there is input in the fieldnames “Korte zijde foto in cm” and “Lange zijde foto in cm”.

    To do this I need to edit the Equation for this field like this:

    when fieldname15 and fieldname16 are emtpy then display o.oo
    when fieldname15 and fieldname16 are each more then 20 then display the outcome of the Equation: PREC(fieldname17*2.32+34.00,2)

    Is that possible?

    Thank you,
    Alwin

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

    (@codepeople)

    Hello @wp-opti,

    The equation in this case would be simply:

    
PREC(IF(fieldname17, fieldname17*2.32+34, 0), 2)

    Best regards.

    Thread Starter Alwin

    (@wp-opti)

    Thank you, that worked!

    However, I have one other equation that need the same rule:

    IF(AND(100>=fieldname2,200>=fieldname6),
    PREC(MAX(3.9,fieldname40*0.60+2.70),2), ‘Maximale maat 100x200cm’)

    So I changend it in:
    IF(AND(100>=fieldname2,200>=fieldname6),
    PREC(MAX(3.9,fieldname40*0.60+2.70, 0) ,2), ‘Maximale maat 100x200cm’)

    But that does not work…

    How can i do this?

    Thank you,
    Alwin

    Plugin Author codepeople

    (@codepeople)

    Hello @wp-opti,

    The solution would be check if the values were entered, before applying the main logic of the equation:

    
IF(AND(fieldname2,fieldname6), IF(AND(fieldname2<=100,fieldname6<=200),
PREC(MAX(3.9,fieldname40*0.60+2.70),2), 'Maximale maat 100x200cm'), '')

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Hide minimum value calculated field’ is closed to new replies.