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

    IF expression for dimension issue

    Richard Hamilton



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



      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!