There are null values in the emp field and i dont need to display that null values in the emp field ..................

[#1]

Plz can any one give expression for this

[saumyashah90]

where are you displaying it?..

in chart or list box or table box where?

If it is a tablebox check on Omit Null Values here

if it is a chart check on supress null values like this:

[#3]

I want to display on straight table

[saumyashah90 · Accepted solution]

yup so second image will work for you.

if at all you want to use it in expression than use:

=if(not isnull(Field),Expression)

[MK_QSL]

Select emp field in the dimension tab and tick suppress when value is null