Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys
I want to sum values bot only for an other distinct column. Here is a little example
Column A: Number (Values: 1, 2, 3, 3, 4, 4, 5)
Column B: sum: Hours (Values: 10,20,5,5, 10,10,5)
So the right sum would be 50, my result is 65. Can anyone give me a little hint?
Thanks for your answer, but it's not working 😞
Within the LOAD script would be a little difficult, since I have a lot of other things that dont have to be distinct loaded
What is the issue? Do you get an error? Wrong number?
It worked, I somehow managed to copy our statement with a mistake Thank you!
Thanks, this fixed my issue as well. I had Sum(DISTINCT{<invoice>}cost) where in my details I was getting $866 as cost but needed to get $1829 your formula corrected it, what was wrong with my formula?
invoice | cost | |
92922|233483 | 545.27 | |
92922|233776 | 321.05 | |
92922|233777 | 321.05 | |
92922|233778 | 321.05 | |
92922|233779 | 321.05 | |
1,829.48 | 866.32 | |
correct | incorrect |