Sum Distinct

[elenarelinque]

Hi!

I want to sum the column "Sum(CANTIDAD RECHAZADA)" only for distinct values in "ID_RECHAZO":

I'm using this expression but it's not working:

Sum( {<[FASE]={"440"},[CODIGO_MAQUINA]={"AN001"}>} TOTAL<CANTIDAD_RECHAZADA> DISTINCT ID_RECHAZO )

Thanks in advance.

[ggijben · Accepted solution]

Hi @elenarelinque , 

Can you try:  

 SUM(AGGR(SUM(DISTINCT  CANTIDAD RECHAZADA), ID_RECHAZO))

[elenarelinque]

It works! Thank you so much!