RE: Why is my total wrong?
I created a saved search and trying to total sales by location. But the total sold qty on the summary page is wrong. It should be 944. I thought grouping by the item and location would work, but it does not. Any ideas on what I am doing wrong?
Rookie Asked on November 23, 2022 in Saved Searches.
I think this might be because of your appliedtotransaction.location join in your formula.
Have you manually added up the values from the detailed view? Are there any duplicate lines?