4 Replies Latest reply: Nov 17, 2016 5:29 PM by jade wind RSS

    exclude value in dimension

    jade wind

      Hi everyone,

       

      I am trying to exclude a value in a dimension and have tried below three methods and keep getting "Invalid dimension" message.

       

      {<[Reason]-={'NO'}>}

      IF(NOT MATCH ([Reason], 'NO'), [Reason]}

      IF([Reason] <> 'NO', [Reason]}

       

      Did I do something wrong?

       

      Thanks in advance!