Contar solo datos duplicados de un campo

[Abri1]

Hola!

Alguien me puede ayudar? necesito contar solo los datos duplicados de un campo, tengo esta formula  COUNT(IF(CODIGO_COMERCIO>1,1,0))   pero no me da el resultado, que podría estar mal?

Gracias

Saludos

[PrashantSangle]

=count({<TRADE_CODE={$(=if(count(TRADE_CODE)>1,1,0))}>} TRADE_CODE)

Regards,

Prashant Sangle

[Abri1]

hi ! 

Sorry!, my question was wrong, what I want to do is count the total of the repeated data, try this formula

=COUNT({<TIPO_TRABAJO={'AVERIA'}>}(CODIGO_COMERCIO + NUMERO_PARTE)>1)

But it doesn't give me the result

[PrashantSangle]

sorry I did not get your query. can you explain with some data??

Regards,

Prashant Sangle

[Abri1]

Yes, I have these fields in my dataset, and I want to count only the fields that are in yellow, the data that is repeated NUMERO_PARTE + CODIGO_COMERCIO with the condition that TIPO_TRABAJO= AVERIA

[PrashantSangle]

can you create composite key of those field in your script?? if yes,

then create composite key of those  field and use that field in expression which I have suggested you in earlier reply.

Thanks & Regards,

Prashant Sangle

[Abri1]

I can't add it to the script, I need to show the result in a KPI