
1. Re: I am trying to code the nested if functions.
rushendra sriram Jan 30, 2016 10:15 PM (in response to rushendra sriram)I am able to satisfy the any one condition with two measure.
Below are the same.
IF [CM Varinace %] <= 0.02 AND [% Variance Amount  CM] <= 0.02 or [CM Varinace %] >= 0.02 AND [% Variance Amount  CM] >= 0.02 then "FLAG" ELSE "NULL" END.
Thank you,
Rushi.

2. Re: I am trying to code the nested if functions.
Adam Crahen Jan 30, 2016 10:16 PM (in response to rushendra sriram)Did you mean a different number than .02 in you 2nd/4th conditions?

3. Re: I am trying to code the nested if functions.
rushendra sriram Jan 30, 2016 10:29 PM (in response to rushendra sriram)Thank you Team,
I just cracked it..
if any alternative are there means plz share. See below code. which satisfy all my condtions. However i not able to give the shapes in my condition formuale.
IF [CM Varinace %] <= 0.02 AND [% Variance Amount  CM] <= 0.02 or [CM Varinace %] >= 0.02 AND [% Variance Amount  CM] >= 0.02 then "FLAG"
ELSEIF [CM Varinace %] <= 0.02 AND [% Variance Amount  CM] <= 0.02 or [CM Varinace %] >= 0.02 AND [% Variance Amount  CM] >= 0.02 then "RED" ELSE "GREEN"
END