Hi,
I think 93.33% maybe the right answer because the average is being calculated in the scope of the whole year or whatever months (Jan-June) included.
While your expectation of the answer being 97.5 % is wrong because, its just the average of percentages of every month.
Just try to take the average of sales for each individual months (For Ex. sales/30) and then for whole year(sales/365) with some random values.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI