Counting numbers

[Jorgitopeter]

Hi people... I read some post in this section, but I can't find out the way...

Here's the situation:

I have the field Customer_ID and the field Order_date . I want to make a calculation field that tells me how many costumers called me. I mean, if, for example, the costumer 1, 3, 10, and 11 called me, I want the calculation tells 4, no matter how may times each customer had called me... I mean, maybe the customers 1 and 10 called me 4 times, and the others 7 times, but I only want to find out how many customers called, not how many calls they made.

I hope my English would be understandable enough :

Thanks a lot people

[Raybaudi]

Hi

we need to know:

1) where you write the customer's call

2) where you write the date ( or timeStamp ) that call was made

3) which period you want to look for ( from Order_date to today ? )

[Jorgitopeter]

1) where you write the customer's call

I have other field called 'Details'

2) where you write the date ( or timeStamp ) that call was made

In the Order_date field

3) which period you want to look for ( from Order_date to today ? )

I want to know the customers who called on June (but don't worry about the period, I thik I can manage to set that)

Here I attach a sample file.

Thanks a lot!!!

Base.zip

[Jorgitopeter]

Hi Danielle, I wanted to know if you could understand what I am trying to do... please ask me to specify whatever you do not understand of my explanation... I mean, you Danielle or anyone who could help me...

Thanks a lot.

Jorge

[Jorgitopeter]

I don't know what happened with the forum, because BruceR answered me and it doesn't show anything... so I paste here BruceR's answer:

' Try this custom function:

http://www.briandunning.com/cf/444 '

It's great ... Thanks a lot BruceR... but I have only one more question: the custom function gives me a list of numbers in the field (1¶2¶9)... Is there any way to count how many numbers are there in the CF-field? I mean, which function would tell me that in the CF field are 3 numbers??

Sorry for my beginner's English.

[Agnès]

Hello,

the custom function gives me a list of numbers in the field (1¶2¶9)... Is there any way to count how many numbers are there in the CF-field?

certainly with ValueCount ()

I think is possible [and better?] without custom function

2 examples, one with ValueListItems ( FileName ; ValueList )

an other with key and ID

I hope I understood.

Agnès

Base_t.fp7.zip

[Jorgitopeter]

Hi my friend... It's really really great!!! And much more quicker than de CF.

However, I can't realize how the field "Base_ID" works, and with what purpose... Thanks for explaining me. Thanks a lot.

[Raybaudi]

Hi Agnes

those two examples work on all records.

What if he have to work with a found set ?