Set Analysis Exclude and Include null

[vardhancse]

Hi All,

Have a requirement is that,

expression:

Sum{$<[Group]={'*'}-{'I'}>}(Sales)

As per the above expression, we are getting sum(sales) where Group I were excluded.

But the issue is that null values were not getting included.

I want to exlude Group I and include null as well.

Is there a way using set analysis.

[#2]

It will exclude your Group I

Sum({<[Group]={'*'}-{'I'}>}sales)

[tobias_klett]

isn't that what it says? to exclude Group one and include null?

[anbu1984]

Check this qvw

[ashfaq_haseeb]

Hi,

Try like this

Sum({$<Group={'*'}+{''}-{'I'}>}Sales)

Regards

ASHFAQ

[vardhancse]

it is excluding null as well

[ashfaq_haseeb]

Hi,

Did you try my solution.

Regards

ASHFAQ

[simondachstr]

Sum{$<[Group]-={'I'}>} Sales)

[vardhancse]

Its not working

[ashfaq_haseeb]

Hi,

I tried its working fine.

Can you post sample application.

Regards

ASHFAQ

[vardhancse]

Created one field in the backed script to satisfy the required condition and used that field in the front end.

if(isnull([Group]) or [Group]='E',1,0) as Group_1,

And used Group_1=1 condition in the expression.

Sum{$<[Group]={1}>}(Sales)

So that Only Group I was excluded and included Group E along with null values.

My issue is resolved