3 Replies Latest reply: Apr 25, 2014 9:41 AM by Hervé Vanderheyden RSS

    Sum of contrat in interval

    Hervé Vanderheyden

      Hello,

       

      I'm in trouble with an expression...

       

      Case:

      Products sold by salesman belong's to categories, and these categories are regrouped by family

      I must count salesman for each interval (Dimension: Strate vendeur) for earch categories

      Intervals are stored in Data Island where "Strate vendeur" is the interval's label field, "Limite inférieure" is the interval's lowest value field  and "Limite supérieure" is the interval's bigest values field. e.g: 1 à 5 --> [1 - 5]

       

      Exemple:

      tab_anv_exemple.png

       

       

      I 've written the following expression "Nombre" : Sum ({$<Matricule={"=Sum(Nombre)>=$(=Min([Limite inférieure]))"}> * $<Matricule={"=Sum(Nombre)<=$(=Max([Limite supérieure]))"}>} [Compteur vendeur]) , but the expression doesn't works because Min([Limite inférieure]) and Max([Limite supérieure]) return 0 and 999 for each rows.

       

      Field "Compteur vendeur" is my Salesman dimension counter (avoid count(DISTINCT Salesman_id))

       

      Pleas help

       

      Regards