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