How do I sum a total that contains identical amounts with sum distinct?
I have a view that takes information from 3 tables and sums a total column from one of the tables. It works until the amount is identical, then it drops one of them. If I change it by a penny, then of course, it works. I have attached a picture of the code and the data table being used. I don't know how to fix this problem.