12 Replies Latest reply: Jan 30, 2014 12:23 PM by Manuel Raggi RSS

    How can I count the customers who have a turnover greater than or less than a certain valu

    Manuel Raggi

      Hello to all.


      How can I count the customers who have a turnover greater than or less than a certain value.

      I have defined a variable that contains the value of turnover
      $ (varFascia1) = 500

      How do you time variables:
      $ (varCurrentYear) = 2014
      $ (varCurrentWeek) = 4 (is the number of the current Week)

      Turnover variable: sum ($(varFatturato))
      in $(varFatturato) contains the field for the calculation of turnover (for example NETTO)

      My formula to count the customers of the working period is as follows:

      count(DISTINCT{<Year={$(varCurrentYear)}, Week={$(varCurrentWeek)}>} CLI_ID)
      (CLI_ID is the client code)


      I have to add to the formula the following condition:

      sum($(varFatturato))< $(varFascia1)

      Should I Count the number of customers that have turnover < 500 ($ (varFascia1))

      I can not find the correct syntax ..
      Can you help me please?

       


      Thanks for everything.