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?

Thank you!

Why is my total wrong?

Why is my total wrong?

Why is my total wrong?

Rookie Asked on November 23, 2022 in Saved Searches.
Add Comment
1 Answer(s)


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?



Intermediate Answered on November 24, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor