Can anyone think of a reason why GP shows differently on a workbook than in an report where the sales numbers match? Both are using sums of Est. Gross Profit at the line level.

are your critera/filters exactly the same?

They are. That's why I'm confused. The report is a summary, the workbook is showing line-level GP.

Most likely offender is selection criteria seems the same but there is some minor difference

It's pretty bare bones. The report filters by class and date and the workbook filters by class and date. Same fields.

Are you 100% sure that it's the same date field? I've had that problem with reports seeming like they use the date field, but in fact use a different date type field.

Okay, so the problem are credit memos.

I've had problems with credit memos flipping signs because NS thinks it's smarter than I am.

I'm really pushing us to use workbooks instead of reports.

Because I should have remembered that with how much pain it caused me when helping a client with sales tax

But I had to prove they are more accurate. I hope this has done the job.

I'm 2+ years away from pushing it on people in comparison to Saved Searches

Haha. Fair enough. The workbooks do lack some functionality and visuals.

I need to be able to download aggreageted data before I try saying it's a better answer.

Right. Our team I think would benefit more from the workbooks, so I'm pushing those. Anything but the reports, of which there are sometimes half a dozen or more variations of one report with one tiny change. It's gotten a bit muddied.