Null Condition in Set Analysis

[mhmmd_srf]

Hi All,

I have below expression :

Count({$<Req_state={3}>}Req_number). However I want to add one more condition that is Closed Date = null.

I am using below script but it is not working.

Count({$<closed_at = {NULL},Req_state={3}>}Req_number)

Could you please help me.

Thanks,

Sarif

[mhmmd_srf]

hi Stefan and Oleg,

Both expression are not working.

Please suggest any other way.

Thanks,

Sarif

[jyothish8807]

Hi Mohammad,

A simply way is to make change in back end.

eg.

Load filed1,

if(len(trim(closed_at))=0,1,closed_at) as closed_at

from<table>.

Now in expression:

Count({$<closed_at = {'1'},Req_state={3}>}Req_number)

Regards

KC

[diego_vazquez]

Hi,

have you tried a simple IF statement in the expression?

This would be like this:

Count(

     IF(isNull(closed_at) AND Req_state = 3,

          Req_number

     )

)

[udit_kumar_sana]

Hi ,

You can use below expression:-

=count({<Req_number={"=isnull(closed_at)"}>} distinct Req_number)

Regards,

Udit