1 Reply Latest reply: Aug 16, 2018 11:06 AM by Richard Hamilton RSS

    IF expression for dimension issue

    Richard Hamilton

      Hello,

       

      I'm having trouble with this IF expression for a dimension on a pivot table.

      Capture.JPG

       

      The last 2 columns are IF functions and are almost identical except the else expression.

      The first IF statement correctly returns null but the second statement returns the else expression even though it meets the same condition expression as the first statement.

       

      Is there an issue with the field I'm using in the else expression?  That field is used as an association on a concatenated table.

       

      Thanks for help!

       

      Rick