2 Replies Latest reply: Mar 20, 2017 10:36 AM by Lawrence Tzigersizoglou RSS

    How to avoid duplicates

    Lawrence Tzigersizoglou

      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])