NEED to include NULL Values in the set anlysis expression

[#1]

Hi,

I need to include the NULL Valus in my set anlysis expression.Please find the once I am using currently.This is not working

Sum

({$<[GName"*"}+""}, [CName] = {"*"}+""}>} AMT

)

please suggest the solutions

[deepakk]

hi,

If you want to include the null value, you can simply write Sum(AMT). This will include the Null Values.

[#3]

sorry it was my mistake did not explained the properly.Actually I have CGroup and Cname columns.I have one drill down using this 2 columns.If i select CGroup then it will list down all the levels below to this.Ex: DELL is CGroup and DELL India,DELL USA,DELL EMEA is my different level under DELL.

Now my requirement is to get the sum of all these levels. I wrote the above stament for this.But in the data I am getting some missed values and NULLs.I need to include them .

pls help

[deepakk]

hi,

No need for set analysis. IN dimension tab there is an option for supressing null values for a particular field.

Try that option , it might help

[#5]

it will supress the NULL Values right..I want to include them..in the expression

[deepakk]

hi,

sum(Amt) will fetch you null values from your two dimesnion. Ou need to write any set analysis.

If you want to show dimension whose values are zero then go to presentation tab there will be a tick on Suppress zero Values, Untick it.

If you are still facing a problem, attach a sample file we would be able to help you out.