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!

Why is my total wrong?

Why is my total wrong?

Why is my total wrong?

Add Comment
1 Answer(s)

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

Intermediate Answered 2 days ago.
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