Null in Set Analysis ?

[#1]

HI All,

I Need to Calculated Blank values in CusGrp by Using Set Analysis, I am getting If I am Using any Specific CusGrp, BUt I need for Blank CusGrp...

Ex: sum({<CusGrp={"OEM"}>}Amt)

CusGrp     Amt

OEM          1000

OEM          2050

-                 3000

LIGHT         4560

-                  2000

LIGHT         3000

Regards,

Heather

[tresesco]

If it is really a null(), you won't be able to capture that in set analysis. You should probably replace the null values in the script by specific symbol or text, may be like:

Set NullAsValue CusGrp;

Set NullValue ='Null';

And then you would be able to filter them in set analysis like:

sum({<CusGrp={"Null"}>}Amt)

[anbu1984]

=sum({<CusGrp={'OEM'}>}Amt) + sum({1-<CusGrp={'*'}>}Amt)

sum({1-<CusGrp={'*'}>}Amt) -- Calculates sum of Amt where CusGrp is null

[ali_hijazi]

or you can do sum(if(isnull(CusGrp),Amt))

[#5]

Now I am getting Value , but Amt is Differnt...

please let me know

[anbu1984]

Check this app.

Note: Used Set Nullinterpret=''; in Script