Why is my total wrong?
Hello!
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?
Thank you!
Hi,
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?
Thanks,
Chris
