Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table, that looks like this:
Number | total costs |
123456 | 200 |
123456 | 200 |
123456 | 200 |
654321 | 400 |
654321 | 400 |
654321 | 400 |
765432 | 200 |
234567 | 300 |
234567 | 300 |
Now I wanna make a sum() over all the costs but with every "total cost" of every "number" only once.
So the sum() should be 1.100 and not 2.600?? Is there a function for this?
Thank you in advance
Tina
Straight table:
Dim: Number
Exp: Sum( Distinct [total costs])
In text box: =Sum(Aggr(Sum( Distinct [total costs]), Number))
Edit: corrected bracket
why don't you load distinct records during load statement?
like Load distinct Number, cost from table
Regards,