Forum Discussion
Nested If Statements
Hi guys, I have 4 measures each recieving a final alpha grade (A,B,C,D). I want to use an IF statement to essentially select specific outcomes for these measures that would match or equal a select o...
Hi cdawidow
You get the wrong answers because your are not grouping your 'or' statements together with paranthesis.
You can also try to rewrite your measure using the 'IN'-function:
IF([SALES RANK] in ("A","B") && [MARGIN FINAL] in ("A","B") && [LOYALTY] in ("A","B") && [FINALCTS] in ("C","D")
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.