How to avoid duplicates

[Anonymous]

Hi There,

i have the following formula on a table that has several same entries of "commande client". I want to avoid having duplicates so, if there are several lines with the same commande client it should count as 1.

Thank you for your help,

count({$<[TIMECURRENTSTATUT]={">5"},[Code]={"3","5","20","25","4"}, [Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])

[viveksingh · Accepted solution]

Hi Lawrence,

Can you try with Distinct

count(distinct {$<[TIMECURRENTSTATUT]={">5"},[Code]={"3","5","20","25","4"}, [Sélection KPI]={"1"},[Regroupement]={"PRO","FIL"}>}[Commande client])

[Anonymous]

Thank you Vivek,

this works fine.

BR,

Lawrence