I hope someone can help as I can't figure it out!I shall try my best to explain.
I have a report to show all sales quotes by status code (first group), then by Category code (2nd Group) and then by sales quote (3rd group) for the first 2 groups there is a coulmn to show no. of quotes using a CountDistinct expression.
My issue is as follows, when running the report by month (Jan, Feb then Mar etc) and taking the total number of quotes for each month and adding them up manually gives a different total when running the report for alll months together (Jan-Mar). For example:
Month No. of Quotes (this is calculated using CountDistinct so not sure if this is the problem?)
When run for Jan-Mar I get a total of 25. Looking at the lines there are quotes missing (when running the report for all (Jan-Mar)) but when run by month the quotes appear?
View Complete Post