Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Good Afternoon
When building a dimension, i would like that the null results could have one name of my choice, and that these Null results could be selected.
the tests i made didn't work well but here is what i have tried,
If ( IsNull ( [Campo1]),'Sem informação', [Campo1] )
Thank you
Fernando Rodrigues
Why don't you perform this in the script?
If(IsNull([Campo1]), 'Sem informação', [Campo1]) as [Campo1]
Hello Sunny,
thank you for your fast response.
I am not confortable in doing this in the scrit.
I am doing this as a Dimension. Is it possible?
thank you
Kind Regards
Fernando Rodrigues
>>and that these Null results could be selected.
If you don't do something like Sunny suggested (or NullasValue) in script, you will not be able to select the nulls, regardless of the how you calculate the dimension. Selections on a calculated dimensions are always applied to the underlying fields and you cannot select the nulls in the underlying.
OK.
Thank you both for your help.
Kind regards