
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Reg:Null in Set Analysis
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you dont want to see those dimensions which have zero values for their expressions, see Chart Properties > Presentation > Suppress Zero Values
Regards,
Gordon
