null values

[master_student]

Hello guys,

I need to know how to delete null values of an expression not a dimension..

Thanks for your help

[trdandamudi]

Can you be little bit more specific...Are you looking to hide a column when it null ?

[miguelbraga]

Hey there,

Try creating a field like this :

if(isnull([you dimension goes here]), 'null', [you dimension goes here]) as MyDimensionWithNullValues,

Then in expression use something like this:

=Sum({$<MyDimensionWithNullValues <> {'null'}>} Sales)

Best regards,

D.A. MB

[miguelbraga]

1. If you don't want to mess with the script do as following:

=Sum({$<[you dimension goes here] <> null()>} Sales)

2. If that don't solve your problem check the Surpress Null Values in all dimension that you have -> Dimensions Tab

3. If that don't for you create an expression like this:

if(isnull([you dimension goes here]), 0,1) * [your expression goes here]

And then check in expression Supress Zero Values -> Presentation Tab

Do you need more solutions?

MB

[Chanty4u]

try below

If(Expression <> 0, Expression)

[jagan]

Hi,

Select Supress Null values option in Presentation tab?

Regards,

Jagan.

[Anil_Babu_Samineni]

Why not simply suppress when value is null from Presentation Tab?

[master_student]

yes

[Anil_Babu_Samineni]

Are you trying this?

If(YourExpession = 0, 0, 1)  From Layout Conditional / What?

[master_student]

it is a filed DATEE that has this format, i need to put in in the expression section :

how to delete '-' values.

Thanks