7 Replies Latest reply: Nov 16, 2017 6:34 AM by seydi Özer

# Not null condition in set analysis

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.

• ###### Re: Not null condition in set analysis

try this

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

or

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

• ###### Re: Not null condition in set analysis

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

• ###### Re: Not null condition in set analysis

Jonathan 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 Ralf has provided should work perfectly if Case Create Date is true null.

• ###### Re: Not null condition in set analysis

try

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

• ###### Re: Not null condition in set analysis

Try this

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

Regards

• ###### Re: Not null condition in set analysis

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

or

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

• ###### Re: Not null condition in set analysis

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