Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this?
Aggr(IF(RowNo()=0, Sum(REVENUE)/COUNT(REVENUE),RangeAvg(Above(RangeSum(REVENUE),0,RowNo()))), (BR_CODE , (NUMERIC, ASCENDING)))
Dear Anil,
It wont produce results, please see why
Thanks
Neville
Please make one example and share expected result
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 |
Please post sample QVW to look and explain the result set in excel. That makes lot help
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
That means you are attaching Image only. Try to follow like attached images in sequence manner
Please attach a sample how I will do this
Thanks
Neville
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