Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I need help with AGGR & SUM:
ID | Line | Position | distance | AGGR function | expected result |
79 | 13 | 1 | 10.000 | 10.600 | 10.600 |
79 | 13 | 2 | 600 | - | 10.600 |
47 | 12 | 1 | 917 | 917 | 917 |
47 | 13 | 1 | 917 | 917 | 917 |
Thanks for your help in advance! 🙂
Swen
This?
sum(aggr(NoDistinct sum(distance), ID, Line))
Or,
SUm(Total <ID, Line> distance)
This?
sum(aggr(NoDistinct sum(distance), ID, Line))
Or,
SUm(Total <ID, Line> distance)
SUm(Total <ID, Line> distance) works fine on a first look.
I did not think that it could work without aggr() 😉