8 Replies Latest reply: Feb 10, 2017 9:39 AM by Andrey Khoronenko RSS

    Relational operator in set analysis

    Lawrence Tzigersizoglou

      Hello,

       

      i am trying to filter a field through set analysis with a set of values less than a number but i cannot make it work. My syntax is:

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

      WHat is not working is the [Délai statut 6 - Statut 3]={"<5"}. If i put or notit gives the same result.

       

      Thank you,

      Lawrence