How to set null condition in set anslysis?

[alex_stone]

Currently, we want to add one condition that close_date = null in set analysis, how to reach that?

e.g.     sum({< close_date={null()} >} total)

But, this expression cannot work.

What can I do if want to add null condition in set analysis? Thanks.

[sunny_talwar]

May be this:

=Sum({<close_date = {"=Len(Trim(close_date)) = 0"}>}total)

or

=Sum({<close_date = {"=IsNull(close_date)"}>}total)

or

=Sum({<close_date -= {'*'}>}total)

[jagan]

Hi,

Try like this

sum({< close_date-={'*'} >} total)

Hope this helps you.

Regards,

Jagan.

[avinashelite]

try like this

=Sum({<close_date = {"=if(Len(Trim(close_date)) = 0,close_date)"}>}total)

or

=Sum({<close_date -= {'*'}>}total)

[Chanty4u]

for more,

=sum({<close_date={'Null'}>}total)

Excluding values in Set Analysis

[alex_stone]

Thank you for your replay, let me try it. Thanks again.