Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Best Community Ever,
I have an expression count( {< DATE_CALCUL={ "$(=date(today()-1))"} >} DN_NUM)
and i would like to add this condition : not isnull(KIT) and not isnull(CODE_BOUTIQUE)
have you any idea ?
Thanks
May be this:
Count({<DATE_CALCUL={ "$(=date(today()-1))"}, KIT = {'*'}, CODE_BOUTIQUE = {'*'}>} DN_NUM)
Count(
{<
DATE_CALCUL={ "$(=date(today()-1))"},
DN_NUM = {"=DN_NUM = Not IsNull(KIT) or LEN(TRIM(KIT))<>0"},
DN_NUM = {"=DN_NUM = Not IsNull(CODE_BOUTIQUE) or LEN(TRIM(CODE_BOUTIQUE))<>0"},
>}
DN_NUM)
Or
Count(
{<
DATE_CALCUL={ "$(=date(today()-1))"},
>}
IF(Len(Trim(KIT))<>0 and Len(Trim(CODE_BOUTIQUE)) <> 0,DN_NUM))
I thought tooooo much (may be) !!!
Hi,
Try this
Count({<DATE_CALCUL={ "$(=date(today()-1))"}, KIT_filter = {'*'}-{'null'}, CODE_BOUTIQUE_filter = {'*'}-{'null'}>} DN_NUM)
IN the backend/script ,create the filters as KIT_filter and CODE_BOUTIQUE_filter displaying 'null' and 'notnull' as description ..... and use the above logic . it will eliminate all the null values
thanks,
Anjee