Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try:
if(len(trim(LVL))>0, LVL)
It will eliminate nulls and blanks, including multiple blanks in the field.
thanks Michael,
It is working fine.