Forum Discussion

Aggro's avatar
Aggro
Frequent Visitor
3 years ago

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 number Invoice number Amount   Note (not in...
Need Help
danextian's avatar
danextian
Super User
3 years ago

Hi Aggro ,

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

Aggro's avatar
Aggro
Frequent Visitor
3 years ago

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