Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance.
Hi,
try this but in Éditer:
if(IssuerSector <> '#N/A', IssuerSector)
and deselected "activer la condition"
Hi,
try this but in Éditer:
if(IssuerSector <> '#N/A', IssuerSector)
and deselected "activer la condition"
The field you are using is to show or not the dimension itself (as a whole)
Create a calculated dimension (instead of your current dimension), and enter your equation:
if (xxxx <> '#N/A', xxxx)
Fabrice
sum( {$<IssueSector = IssueSector - {"#N/A"}) >} Sales )
Use this
if(IssuerSector <> '#N/A', IssuerSector)
inestead of your current dimension. You can modify your current dimension with the Éditer button that you have in your snapshot.
I just needed to modify the expression in the "Editer" section not in the field I was writing in, thanks a lot
you welcome.