Moving Average & its total

[nevilledhamsiri]

Dear All!

Please check why the total wont come accurately over averages calculated. Excel used is also attached here.

Expression applied in calculation is as follows!

AVG(AGGR(SUM(PREMIUM),BR_CODE,MONTH))

AVG(AGGR(SUM(EXPENSES),BR_CODE,MONTH))

Thanks

Neville

BR_CODE	MONTH	PREMIUM	EXPENSES	INCOME
RA	JUL	6,800,000	2,500,000	500,000
RA	AUG	6,900,000	2,800,000	650,000
RA	SEP	7,200,000	3,200,000	750,000
EH	JUL	2,800,000	850,000	(125,000)
EH	AUG	3,200,000	900,000	(100,000)
EH	SEP	3,100,000	925,000	(75,000)
K7	JUL	1,400,000	450,000	125,000
K7	AUG	1,500,000	550,000	150,000
K7 BR_CODE CLAIMS RA          3,500,000 EH          1,500,000 K7              750,000	SEP	1,600,000	600,000	100,000

[sunny_talwar]

Thank you sir