cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aggro
Frequent Visitor

Calculate data without duplicate values and additional decimal issues

Hi 

 

I want to sum the amount column without the duplicated amount and decimal issues.

 

Current Data:    
     
Tracking numberInvoice numberAmount Note (not in the table)
ABCD-1234XYZ7 << Duplicated
ABCD-1234LMN7  
ABCD-1234PQWE1  
ABCD-1235SDA5 << Duplicated
ABCD-1235EWRW5 << Duplicated
ABCD-1235OPWE5  
ABCD-1235TWERT750 decimal issues, which is the 100th  of the other record
ABCD-1235TWERT7.5  
ABCD-1236QOWOE6  
     
     
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  
2 REPLIES 2
danextian
Super User
Super User

Hi @Aggro ,

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






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors