# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Specialist

## Moving Average & its total

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(EXPENSES),BR_CODE,MONTH))

Thanks

Neville

RAJUL         6,800,000    2,500,000     500,000
RAAUG         6,900,000    2,800,000     650,000
RASEP         7,200,000    3,200,000     750,000
EHJUL         2,800,000       850,000   (125,000)
EHAUG         3,200,000       900,000   (100,000)
EHSEP         3,100,000       925,000     (75,000)
K7JUL         1,400,000       450,000     125,000
K7AUG         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

1 Solution

Accepted Solutions
Highlighted
MVP

So, for the total you want to sum them? May be this

10 Replies
Highlighted
MVP

What are the expected numbers? Where is the Excel attached?

Highlighted
Specialist

Hi, Sunny,

It is not attached rather presented in the body of the doc itself. Average considered from July to Sep which is shown in the excel with the formula used!

Thanks

Neville

Highlighted
MVP

68+69+72/3 = 69.67 which is what you got for RA.. what is the issue?

Highlighted
Specialist

You are right but see the total of (EH+K7+RA)=3.8 which is wrong. It has to be 11.4. Though the individual Branch figure is ok, once all BR_codes are totaled up figure appears to be wrong!

Highlighted
MVP

So, for the total you want to sum them? May be this

Highlighted
Specialist

Thanks sunny, It works

Neville

Highlighted
MVP

Just don't understand how is this the correct answer?

Can you explain what in this response of your make it a correct response? If thanks was the answer to all your problems, then I can keep responding thanks to all your future posts

Highlighted
Specialist