
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Networkdays in set analysis
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much,
this works fine.
