Aggr calculation

[betty2]

Hello,

Can you help me solve this problem? I have this table containing an ID and an X_ID

 I need to calculate the number of IDs that have more than two X_IDs, for example:

The ID=1040 have 4 X_ID (2000,2005,2007,50) and the ID=1700 have 3 X_ID(3000,3009,3090)

In this case we have two IDs that have more than two X_IDs

I think I need to use the AGGR function but I'm not sure how.

THanks in advance.

[Luisanabria]

Hi

I dont know if my idea is correct but l could try using IF

Maybe something like this:

IF(id=1040,Count(x_id),id=1700,count(x_id))    as  Countfield

Hope l could help

[BrunPierre]

Hi,

Possibly as below.

=Count({$<ID={"=Count(ID)>1"}>} DISTINCT ID)

[vinieme12 · Accepted solution]

minor change to make it logically correct

=Count({<ID={"=Count(Distinct X_ID)>1"}>} DISTINCT ID)