Sum for each number expression

[khaycock]

I'm trying to get a total sum of the total price column but I have some duplicate fields and only want to pick up one 'Total Price' amount per 'Invoice Number'. For instance, for invoice number 14735 there are 3 different fields with the value 1064.4 but I only want to use one of them in the sum expression.

Any ideas as to what expression I could use?

Thanks

[qlikview979]

Hi please share sample app

[jonathandienst · Accepted solution]

This should do it:

=Sum(Aggr(Only([Total Price]), [Invoice Number]))

I suggest that you re-examine the data model to create a table in which these amounts are not duplicted and possibly amend the model/front end so that you are not making spurious duplicates from incorrectlty associated dimensions.

[khaycock]

Here is one. Thanks.