How Could I do this ratio?

[ecabanas]

I have this example table:

SalesId   CustomerID   date

1             A                   jan-12

2             B                   Jan-12

3             C                   Jan-12

4             A                   Feb-12

I want to know the number of salesId which has ben bough two times

count({<SUM(count(SalesID))>=3>} CustomerID)

thank's to all

[#2]

create new text object and in text  write

=Count(SalesID)

you dont need to filter

see the attached image

[ecabanas]

Hi Fahad,

Thank you for your compiled example, but oone question, what is the "RepeatedTime" in the function?

it does not calculate correctly

[#4]

Hi,

The "RepeatedTime" is the field Name which calculates the number of time the customer has purchased.

It is a new filed created in the Script.

for example CustomerID = "A" has made 4 purchases, the script counts and stores it in the field "RepeatedTime" for all the instanses  of CustomerID = "A" in data.

You could look into the script..

Thanks

[ecabanas]

You are the ONE!!!

Thank's!!! if you come to Barcelona you are invited to a beer 🙂