nul values

[master_student]

Hello nice people

I would like to add a condition in my expression; the condition is to count cases only if the status dimension <> from nul

here is the expression  :

=count(if(LONG_DESC_STATUS <> 'Demande ' AND LONG_DESC_STATUS <> 'Info ' AND LONG_DESC_STATUS <> 'Abandonné' AND LONG_DESC_STATUS <> ' ',if((date([Date création],'DD/MM/YYYY'))>=(date(Max_date-7,'DD/MM/YYYY')),CASE_ID)))

it didn't work, it always count the null values of the LONG_DESC_STATUS dimension.

Any idea please

Thanks a lot

[Anonymous · Accepted solution]

did you test with isnull?

AND not isnull(LONG_DESC_STATUS),if

similiar would be do use len

AND len(LONG_DESC_STATUS)> 0,if

[master_student]

Thanks a lot

[Anil_Babu_Samineni]

Perhaps This

If(notIsNull(LONG_DESC_STATUS),Count(LONG_DESC_STATUS -={'Demande ','Info','Abandonné'} CASE_ID))

First try The above then try the below one

If(notIsNull(LONG_DESC_STATUS),Count({<LONG_DESC_STATUS -={'Demande','Info','Abandonné'}, [Date création] = {'>= (Date(Max_date)-7) '}>} CASE_ID))