Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I need to know how to delete null values of an expression not a dimension..
Thanks for your help
Can you be little bit more specific...Are you looking to hide a column when it null ?
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
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
try below
If(Expression <> 0, Expression)
Hi,
Select Supress Null values option in Presentation tab?
Regards,
Jagan.
Why not simply suppress when value is null from Presentation Tab?
yes
Are you trying this?
If(YourExpession = 0, 0, 1) From Layout Conditional / What?
it is a filed DATEE that has this format, i need to put in in the expression section :
how to delete '-' values.
Thanks