multi conditions

[master_student]

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

[sunny_talwar]

May be this:

Count({<DATE_CALCUL={ "$(=date(today()-1))"}, KIT = {'*'}, CODE_BOUTIQUE = {'*'}>} DN_NUM)

[MK_QSL]

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)

[MK_QSL]

Or

Count( 

  {<

  DATE_CALCUL={ "$(=date(today()-1))"},

  >}

IF(Len(Trim(KIT))<>0 and Len(Trim(CODE_BOUTIQUE)) <> 0,DN_NUM))

[MK_QSL]

I thought tooooo much (may be) !!!

[veeranj]

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