Dealing with null values in expressions

[nkosinde13]

Hi, I want to show only values that have nulls on my straight table, how do I include this condition on an expression?

So e.g, in the example that I attached I want my table to return only Acc Num 223 and 200.

Thanks

[Chanty4u]

try caluclation dimension

If(Len(Trim([Field])) = 0, 'Null', Null())

[sibin_jacob]

you need to write your dimension as

If(Len(Trim(Ind)) = 0, [Acc Num])

Then check the suppress when value is null

Then add your expression

for example Sum(sales) or for testing add expression as 1

It will show values only for Acc Num 223 and 200.

[nkosinde13]

Thank you all very much, it works perfectly 🙂

[Chanty4u]

Nice Please close the thread by making correct and helpful