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.