Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Fantastic ...!
Both solutions work.
Thank you so much aid.
Bye
OK
I try now your solution.
Thank you for everything ..
Bye
Hello Fabrice,
I tried the solution 2 works perfectly.
thanks
Manuel