How to count Duplicate Id's only?

[#1]

Hi ,

I want to count only duplicate id's.

Ex:

id

1

2

3

4

5

1

2

1

3

2.

In above 1,2,3 id are repeating so my output count should be:3 

How we can calculate????

[tresesco · Accepted solution]

Try something  like:

=Count (If(Aggr(Count(id),id)>1,id) )

Edit: Parenthesis correction

[christian77]

Hi.

COUNT(

IF(

AGGR(COUNT(ID),ID)

>1

,1)

[christian77]

that was fast.

I think your first count needs distinct.

[jagan]

Hi Ashok,

Try this

=Sum(Aggr(If(Count(id) > 1, 1, 0), id))

Regards,

Jagan.

[#6]

Hi

tx for ur reply, but in above case i am getting difference value means

above expreesion works like this

=count(distinct id )-count(id)

I need count of id's where repeting more than once's

[er_mohit]

try this in text object

=Count(Aggr(NODISTINCT Count(id),id))

[swuehl]

Or try

=count({<id = {"=count(id)>1"}>} distinct id)

[tresesco]

Nope! I guess you are missing somewhere. Because that is already aggregated. Isn't it so?

[#10]

Can anybody tell me how to do that in script?