Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks a lot
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))