Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Oliver,
almost correct, you only need to sum the different results of the aggr function:
=Sum(Aggr(count(LiefDatum), ShipID, AdrEmpf))
Hi Oliver,
Please post some sample data.
Hi Oliver,
almost correct, you only need to sum the different results of the aggr function:
=Sum(Aggr(count(LiefDatum), ShipID, AdrEmpf))
Hi,
Try below expression
Sum
(Aggr(count(LiefDatum), ShipID, AdrEmpf))
why do you need to aggr, you can use normal count like =count(LiefDatum) and it will return 87, what is your need?
Hi all
Thanks a lot!
Cheers
Oliver