Aggr function

[#1]

Hello,

I have the following values in a table

I am looking to add the values in the to_send column for every [id Campaña].

The result I am expecting is 8:

3 [id Campaña=2] + 3 [id Campaña=3] + 2 [id Campaña=4] = 8

I've been trying to use the aggr function: AGGR(SUM(to_send),[id Campaña])  but I couldn't get that result.

Any ideas con how to solve this?

[Anonymous · Accepted solution]

If there's always just one unique to_send value for each Campana, then you should be able to do:

sum(AGGR(SUM(distinct to_send),[id Campaña]))

or you could use Max() (or min() 😞

sum(AGGR(MAX(to_send),[id Campaña]))

[#3]

Shudn't u expect 8 instead of 6, 3+3+2=8

Why 6 ?

Regards

[#4]

yes you are right, it should be 8...I already corrected it.

[#5]

Thank you for your help Johannes..it's working!