I've got another weird one. I run a daily report that slices and dices the information into several different views. All of the totals should be the same. However, 2 of the 3 return the correct view, but the third does not. I've checked all of the filters, dates, types of orders and order channels. I've checked to make sure that the 'Analysis - totals - total all using' is set to sum. Can anyone think of anything else that I might check to correct this?
Many thanks in advance;
Without looking at your workbook, it's hard to say. One thought comes to mind...are there any table calculations used? Are they going in the correct direction on all sheets?