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.