Not null condition in set analysis

[rajarshi_guin]

Hi All,

I have a measure in which the set analysis condition is not null. The measure is Count([Case ID]) where Case Create Date is not null.

So will the formula of this measure be Count({<[Case Create Date]-={*}>}[Case ID])?

Can anyone please let me know the proper syntax of writing this set analysis.

Thanks.

[arulsettu]

try this

Count( {$<[Case Create Date]={"=Len(Trim([Case Create Date]))>0"}>}[Case ID])

or

Count( {$<[Case Create Date]={">0"}>}[Case ID])

[jonathandienst]

Nulls will not be included in the Count. No set expressions required.

[Chanty4u]

try

=Count(if(isnull([Case Create Date]),[Case ID]),[Case ID])

[seydiozer]

Try this

Count({<[Case Create Date]-={"","NULL"}>}[Case ID]

Regards

[sasiparupudi1]

Count(If(Len([Case Create Date])>0,[Case ID])

or

Count({$<[Case ID]={'=Len(Trim([Case Create Date]))>0'}>}[Case ID])

[rbecher]

Count({<[Case Create Date]={"*"}>}[Case ID])

[sunny_talwar]

jontydkpi‌ I think the OP wants to count Case ID where Case Create Date is not null. I think in this case, since Case ID is not null, it might still get counted. I think what rbecher‌ has provided should work perfectly if Case Create Date is true null.