Continuety of Running Avearge

[nevilledhamsiri]

Hi,

Please refer my chart where only three months actual were stated with balance months zero values. But Running average calculated continue with different values.Of course for Ra eg, it should be 6.8 millions even for rest of the Months.Please see why this is so!

Expression used as follows!

IF(RowNo()=0,  Sum(REVENUE)/COUNT(REVENUE),RangeAvg(Above(RangeSum(REVENUE),0,RowNo())))

Thanks

Neville

[Anil_Babu_Samineni]

Try this?

Aggr(IF(RowNo()=0,  Sum(REVENUE)/COUNT(REVENUE),RangeAvg(Above(RangeSum(REVENUE),0,RowNo()))), (BR_CODE , (NUMERIC, ASCENDING)))

[nevilledhamsiri]

Dear Anil,

It wont produce results, please see why

Thanks

Neville

[Anil_Babu_Samineni]

Please make one example and share expected result

[nevilledhamsiri]

This is my excel where said expression was derived at!

BR_CODE	MONTH	REVENUE	COMM
RA	JUL	6,900,000	1,200,000
RA	AUG	6,800,000	1,150,000
RA	SEP	6,700,000	1,300,000
RA	OCT
RA	NOV
RA	DEC
EH	JUL	2,800,000	350,000
EH	AUG	2,700,000	250,000
EH	SEP	2,500,000	300,000
EH	OCT
EH	NOV
EH	DEC
K7	JUL	1,200,000	250,000
K7	AUG	1,100,000	350,000
K7	SEP	1,500,000	150,000
K7	OCT
K7	NOV
K7	DEC

[Anil_Babu_Samineni]

Please post sample QVW to look and explain the result set in excel. That makes lot help

[nevilledhamsiri]

Dear Anil,

Once I try to attach qvw  below message comes up. Please see why it is. I used the above icon looks like a camera to attach my qvw file.

''That image type is forbidden"

Thanks

neville

[Anil_Babu_Samineni]

That means you are attaching Image only. Try to follow like attached images in sequence manner

[nevilledhamsiri]

   Please attach a sample how I will do this

Thanks

Neville

[Anil_Babu_Samineni]

Attach missing.. Please make sure to provide output where we need to get. And please read provide link Uploading a Sample

POS - Please start from second image from this discussion