Sum repeated values​​.

[Anonymous]

Hello all.

I'm struggling to find the correct function.

In this table, the result must be 24.
The sum should consider the repeated numbers.

Thank you.

[#2]

It looks like the equations is doing right.

Could you tell me why it should be 24?. Please explain the logic

[#3]

Try this:

aggr(sum( distinct Quant_Fornecedores),Fornecedor)

(Change the Total Mode to Sum of Rows)

[Anonymous]

I need to count how many COD_FORNECEDOR  I have   for NRO_SEQ_PEDIDO.

Note that I have 2 different records in the field NRO_SEQ_PEDIDO
and 4 different records in the COD_FORNECEDOR field .

The correct result is 4 records.

NRO_SEQ_PEDIDO     COD_FORNECEDOR         SUM

                                                                             4

978645                              19022                            2

978645                              19782                           2

978795                                3112                           2

978795                                8782                           2

[#5]

Try  this

aggr(count(Distinct COD_FORNECEDOR),NRO_SEQ_PEDIDO)