Expression - suppress when null

[#1]

Hi,

Is it possible to suppress values when null for expressions the same way you can do it for dimensions?

Thanks in advance

[#2]

Yes It is very much possible in dimesion too.

Same as expression you can surpress null value in dimension also.

[#3]

Thanks for the reply.

Do you know how to? Is there a tickbox or anything because I can't seem to find one

[#4]

Please find the attached snapshot and do the same in streight table or pivot ........

Please mark as answered if problem solved.

Regards,

Dushyant

[#5]

Thanks Dushyant,

The screenshot you sent is to suppress null values for dimensions. I'm looking for how to suppress null values for expressions.

What I am working on is a pivot table and my expression works out the total revenue. What I want to do is when say the month of May (dimension) has no revenue (expression). It will remove the whole row.

[#6]

it is not the perfact solution but it will work.

Use the expression simmilar to below in presentation tab instead of number you insert to limit the number of row displayed.

=====================

sum(if(isnull(<Expression>),1,0)

=====================

i hope this will help....

it is not gud for large data set.

its a temperory solution.

Regards,

Dixit

[ToniKautto]

One option to suppress the rows where you have null in an expression is to add a calculated dimension.

For example;
=if(not IsNull(F2), F1)

Where F1 is the dimension field and F2 is the expression.

[#8]

Hello Tony,

What happen if your expression contain same field whatever you have used in dimension?

It is for my knowledge. Because right now i am not able to test that one.

Thanks,

Dixit

[ToniKautto]

Calculated dimension can have a quite bad impact on performance, so you really do not want to have too heavy calculations in the dimension.

What is the reason to hide rows with null expression results? Is the null a result of data model not being perfect?