6 Replies Latest reply: Feb 18, 2014 10:57 AM by Luis Ernesto Castillo Villanueva RSS

    Exclude a value in a chart

      Hi there are a lot of answer on that subject but no one seem to work for me, so it may have been already answered.

       

       

      I have a dimension 'IssuerSector' whitch can be '#N/A' I need to exclude this value in a chart.

       

      I tried an if condition:
      if(IssuerSector <> '#N/A', IssuerSector), or if(IssuerSector <> '#N/A', null(), IssuerSector).
      It never worked. I even tried to replace it by another value: if(IssuerSector = '#N/A', IssuerSector = 'Government') it didn't work either.


      How can I exclude this value?

      Here a is the proporties, maybe I forgot something.

      IssuerSector.png
      Thanks in advance.