This content has been marked as final. Show 6 replies
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.