10 Replies Latest reply: Mar 18, 2014 8:55 AM by Bill Britt RSS

    "IF (OR..."   conditional statement

      Hi everyone,


      I'm trying to create a calculated dimension using an "if(or..." conditional expression.


      The statement is: IF(OR(FieldA = 'Value1', FieldA = 'Value2'),"Value 1,2", "NotValue1,2")


      But I get errors. I'm using typical Excel conditional formatting syntax, assuming this would apply.


      My objective is to get two cases: a) Value 1,2 and b) NotValue 1,2


      and then use these in a pivot table to show summary results.