Conditional with jerarquic dimmension

[#1]

I have a jerarquic dimmension

I have null values in the expression

I wanna do something like this

=if (isnull(JERARQUICDIMENSION), 'NULL', "JERARQUICDIMENSION")

It isn't working. It seems like i'm seeing the first dimmension of the jerarquic

Thank you

Greetings

[sunny_talwar]

Is this a dimension? May be try this:

If(Len(Trim(JERARQUICDIMENSION)) <> 0, JERARQUICDIMENSION)

[#3]

yes! is a dimmension

I think it's not working

The dimension should be

if is null = 'Null value'

If not = ' Dimension'

[sunny_talwar]

Above is working the same way as you have described, Have you checked "Suppress When Value Is Null" on the dimensions tab???

The box should have tick mark next to it.

HTH

Best,

Sunny

[#5]

Yeah. Sory if i didn't expressed myself well.

I dont' wanna supress the null values. I wanna have a name for that. In this case it would be 'No Client'

You understand ?

Thank you

Greetings

[sunny_talwar]

Try this:

If(Len(Trim(JERARQUICDIMENSION)) <> 0, JERARQUICDIMENSION, 'No Client')