3 Replies Latest reply: Jun 16, 2016 12:28 PM by Sunny Talwar RSS

    How to suppress null values in an expression

    Cliff Clayman

      I have an expression that produces some null values that I do not want to see.  I know there is an option to suppress nulls in a dimension, but how can I do it in the following expression:

       

      =If(WildMatch([VendorNum], 'TRA*'),[VendorNum])