Excluded null values

[Anonymous]

Hi..

In set analysis how we excluded null values for perticular field..

Please Help me..

Thanks,

[ashfaq_haseeb]

Hi,

Filtering Null is a tricky part.

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

If possible share sample app to look over.

Regards

ASHFAQ

[#3]

eg: to exclude null values

sum({<status -= {''}>}sales)

or

sum({<status = {'*'}-{''}>}sales)

[#4]

sum({<resoveddate-={''}>}sales)

[MK_QSL]

Consider that you have sales data with Customer, Date and Sales as Fields and Date field is having Null Values... You can find Total Sales wherever Date is not null as below

SUM({<Date = {'*'}>}Sales)

If the above is not working, you need to assign blank or - values of Date as Null.

Use below code in Script which will replace Date

IF(IsNull(Date) or Len(Trim(Replace(Date,'-','')))=0,Null(),Date) as Date