exclude value in dimension

[Anonymous]

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!

[Chanty4u · Accepted solution]

try below

if([Reason] <> 'Fieldvalue', [Reason])

[Chanty4u]

or you can try below aswell

if([Reason] <> 'Fieldvalue', [Reason],null())

[Anonymous]

Thanks Chanty for trying to help. I tried both and still not working...

[Anonymous]

My bad! I just discovered that I used the curly bracket to end instead of the round bracket! That's the whole reason why it wasn't working! Thanks Chanty for your patience....