Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
Try something like:
=Count (If(Aggr(Count(id),id)>1,id) )
Edit: Parenthesis correction
Try something like:
=Count (If(Aggr(Count(id),id)>1,id) )
Edit: Parenthesis correction
Hi.
COUNT(
IF(
AGGR(COUNT(ID),ID)
>1
,1)
that was fast.
I think your first count needs distinct.
Hi Ashok,
Try this
=Sum(Aggr(If(Count(id) > 1, 1, 0), id))
Regards,
Jagan.
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
try this in text object
=Count(Aggr(NODISTINCT Count(id),id))
Or try
=count({<id = {"=count(id)>1"}>} distinct id)
Nope! I guess you are missing somewhere. Because that is already aggregated. Isn't it so?
Can anybody tell me how to do that in script?