Problems with AGGR function

[#1]

Hi all

I have to calculate the number of shipments aggregated by Adress and Shipping ID

The correct outcome should be 87. (in Excel)

I used this formula: =Aggr(count(LiefDatum), ShipID, AdrEmpf)

My result in QV is 1 😞

What's wrong? Would be nice if somebody could give me a tipp

Oliver

[ashwanin]

Hi Oliver,

Please post some sample data.

[rubenmarin · Accepted solution]

Hi Oliver,

almost correct, you only need to sum the different results of the aggr function:

=Sum(Aggr(count(LiefDatum), ShipID, AdrEmpf))

[perumal_41]

Hi,

Try below expression

Sum

(Aggr(count(LiefDatum), ShipID, AdrEmpf))

[maleksafa]

why do you need to aggr, you can use normal count like =count(LiefDatum) and it will return 87, what is your need?

[#6]

Hi all

Thanks a lot!

Cheers

Oliver