ignore duplicate records

[Anonymous]

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

[tresesco]

Straight table:

Dim: Number

Exp: Sum( Distinct [total costs])

In text box: =Sum(Aggr(Sum( Distinct [total costs]), Number))

Edit: corrected bracket

[big_dreams]

why don't you load distinct records during load statement?

like Load distinct Number, cost from table

Regards,