Sum field B if field A is distinct

[#1]

Dears,

How can I sum all the values of field B, only if field A is distinct.

In other words.

Collect all distinct values of field B, and sum its column A value.

Thanks per your attention,

Best regards,

[kaushiknsolanki]

Hi,

     Would you please give an example for more clarification.

Regards,

Kaushik Solanki

[#3]

Sum({<Distinct SN>} TotalLabor)

SN the number to be distinct

TotalLabor the number to be summed!

Thanks

[#4]

Sum({<Distinct SN>} TotalLabor)

SN the number to be distinct

TotalLabor the number to be summed!

Thanks

[kaushiknsolanki]

Hi,

     Could you please explain with example.

Regards,

Kaushik Solanki

[jagan]

Hi,

It is not possible, you need to arrive a flag for the first value in the script , so that you can directly sum up the values.

Can you please come up with sample data and example.

Hope this helps you.

Regards,

Jagan.

[#7]

You probably already had solved this problem,however, recently I've tryied to solve that question and it was not too easy to be solved.

It could be solved with it:

sum(aggr(sum(DISTINCT B), A))

[deshikas]

Had the same issue your solution fixed for me.  Thanks Luiz