Reg:Null in Set Analysis

[#1]

Hi All,

In set analysis how to mention the null() function in expression.

For Ex:

The expression like Sum(if(Req_Qty >0,Req_Qty ,null())

I would like to replicate this in set analysis.if any one know share with me the same

Thanks & Regards

Jai

[#2]

If you do not specify a value for a 'then' or 'else' in a condition then null is returned.

For example

if(Req_Qty >0,Req_Qty )

then where Req_Qty is not >0 then null is returned.

Logically though when using an aggregation function (SUM) you would want to return 0 rather than null anyway.

Regards,

Gordon

[#3]

Hi,

In this case I will get '0' values for qty <0,But I want to show null in table.Basically I dont want to show '0' values

Thanks & Regards

Jai

[#4]

If you dont want to see those dimensions which have zero values for their expressions, see Chart Properties > Presentation > Suppress Zero Values

Regards,

Gordon