Drill Down Group

[brindlogcool]

Hi,

I am trying to create an expression in the Drill down group as

If(ISNULL(LVL) =0 or ISNULL(LVL)<>' ' , LVL )

But still it is showing the blank value in the straight table. It has the expression. I want to supress the row if the dimension is blank.

Is there anything i am missing?

[Anonymous]

Try:

if(len(trim(LVL))>0, LVL)

It will eliminate nulls and blanks, including multiple blanks in the field.

[brindlogcool]

thanks Michael,

It is working fine.