Networkdays in set analysis

[Anonymous]

Hi there,

i want to calculate the count of a given field "Commande client" with some criterias and if the difference of a date filed "Date de creation" from today is bigger than 5 days.

I am using set analysis but i cannot intergrate networkdays function in it and make it work.

count({$<[Délai statut 6 - Statut 3]={"999999"},[Regroupement]={"PRO","FIL"}>}[Commande client])

I would like to add in the expression the following: networkdays(([Date de création]),today())">5" but i need help with the syntax.

Thank you for your help,

Lawrence

[sunny_talwar · Accepted solution]

May be this:

Count({$<[Délai statut 6 - Statut 3] = {"999999"}, [Regroupement] = {"PRO","FIL"}, [Date de création] = {"=NetWorkDays([Date de création], Today()) > 5"}>} [Commande client])

[Anonymous]

Thank you very much,

this works fine.