Calculate data without duplicate values and additional decimal issues

Question

Hi&nbsp;&nbsp;I want to sum the amount column without the duplicated amount and decimal issues.&nbsp;Current Data:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tracking numberInvoice numberAmount&nbsp;Note (not in the table)ABCD-1234XYZ7&nbsp;&lt;&lt; DuplicatedABCD-1234LMN7&nbsp;&nbsp;ABCD-1234PQWE1&nbsp;&nbsp;ABCD-1235SDA5&nbsp;&lt;&lt; DuplicatedABCD-1235EWRW5&nbsp;&lt;&lt; DuplicatedABCD-1235OPWE5&nbsp;&nbsp;ABCD-1235TWERT750&nbsp;decimal issues, which is the 100th&nbsp; of the other recordABCD-1235TWERT7.5&nbsp;&nbsp;ABCD-1236QOWOE6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected Result:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tracking number&nbsp;Expense&nbsp;Note (not in the table)ABCD-1234&nbsp;8&nbsp;expense is 7 +1 without that duplicateABCD-1235&nbsp;12.5&nbsp;expense is 5+7.5&nbsp; without that duplicate and 100th of the recordABCD-1236&nbsp;6&nbsp;&nbsp;

danextian · Answer

Hi Aggro ,
Sans the notes, how do you know which ones are the duplicates?

aggro · Answer

I don't, but at this time, we want only to sum up one record instead of all (among the duplicate ones).&nbsp;

Forum Discussion

Calculate data without duplicate values and additional decimal issues

2 Replies

Related content

Duplicate ranking

remove duplicate value within a row

Removing Duplicates

Additional calculation row in matrix

SIlver Layer - Additional Columns

Current Data:

Tracking number	Invoice number	Amount	Note (not in the table)
ABCD-1234	XYZ	7	<< Duplicated
ABCD-1234	LMN	7
ABCD-1234	PQWE	1
ABCD-1235	SDA	5	<< Duplicated
ABCD-1235	EWRW	5	<< Duplicated
ABCD-1235	OPWE	5
ABCD-1235	TWERT	750	decimal issues, which is the 100th of the other record
ABCD-1235	TWERT	7.5
ABCD-1236	QOWOE	6


Expected Result:

Tracking number		Expense	Note (not in the table)
ABCD-1234		8	expense is 7 +1 without that duplicate
ABCD-1235		12.5	expense is 5+7.5 without that duplicate and 100th of the record
ABCD-1236		6