AnsweredAssumed Answered

Calc combining 'and', 'or'

Question asked by tays01s on Mar 9, 2018
Latest reply on Mar 10, 2018 by tays01s

I'm struggling with a seemingly easy calc. If I use either the bold or non-bold contents of the 'IF' function, both work correctly. However, I can't the 3 'or' alternatives to work with the 'and' parts of the calc. Does FM have a perculiar hierarchy when dealings with 'and/or' and parentheses?

If(

K>0 and K>Biochem_Min_Max::K_min and

 

Mg>0 and Mg>Biochem_Min_Max::Mg_min and

 

((IsEmpty(Biochem_Date_minus1::__uuID) and P≥1) or (Biochem_Date_minus1::P≥1 and P≥1) or

(P>0 and P ≥ 1.2)); ""; 1)

Outcomes