Hello,

I've scratched my head now for several hours and two days. I can't seem to find the cause of this. I've tried to troubleshoot this so many different ways. My Criteria and Results are attached (See attached 'Old Results'), as I wanted to bring in Cost Price, Selling Price & Category.

TL;DR –

Shows me incorrect amount even though my formula is correct. Drilling down shows me correctly, however, exporting it displays more than 12,000 Results because of the Duplicate Categories. Removing these still shows me over 896 Results. The Qty is being displayed as 289 – The Correct QTY should be 103. Strange that the amount is showing correctly $3618.

Apologies for my lack of explanation –

Hello,

I ran an item saved search to show me transaction history for the whole of 2017 using Formulas. I included Item Category because I needed to know which category was doing more Sales, I also included Cost Price and Selling Price.

Because of this – My QTY was showing me in thousands and I knew this was incorrect. I did an elimination of removing certain fields to try and figure it out and it was because of categories as certain of our products has multiple categories – BUT, the QTYs are still showing me in the hundreds. So I removed the Cost & Selling price and the figure hasn't changed i.e. it's still the same.

I then drilled into this to see where the problem lied and the QTY displayed correctly. Now I can't seem to find where the problem is.

Can anyone advise, please?
This is a cached copy. Click here to see the original post.