Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
Count( {$<[Case Create Date]={"=Len(Trim([Case Create Date]))>0"}>}[Case ID])
or
Count( {$<[Case Create Date]={">0"}>}[Case ID])
Nulls will not be included in the Count. No set expressions required.
try
=Count(if(isnull([Case Create Date]),[Case ID]),[Case ID])
Try this
Count({<[Case Create Date]-={"","NULL"}>}[Case ID]
Regards
Count(If(Len([Case Create Date])>0,[Case ID])
or
Count({$<[Case ID]={'=Len(Trim([Case Create Date]))>0'}>}[Case ID])
Count({<[Case Create Date]={"*"}>}[Case ID])