How to use isnull() in Set Analysis?

[Anonymous]

I want to use "sum(if(isnull(Department)=0,Sales))", but how can I achieve by useing Set Analysis?

[deepakk]

hi,

You check the null condition in script. This will make the expression easy at reporting level.

If(isnull(Fieldname) =-1,'Y','N') as Indicator

at expr:

sum({<Indicator ={"Y"}>} Amount)

[Anonymous]

Thank you Deepak Kurup, but how can you achieve it without creating a new field "Indicator"?

[sparur]

Hello, John

try this:

sum({$<[Department]={"=Len(Department) = 0"}>} Sales)

or

sum({$<[Department]={""}>} Sales)

sorry, for you task it will be like this:

sum({$<[Department]={"=Len(Department) > 0"}>} Sales)

[Anonymous]

Thank you, sqarur.

[#6]

I think the Len function only works when your value is not really a null, but an empty string.

The difference is subtle,  but there IS a difference.