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
Thanks Dear Anil,
Please see now!
Neville
Hi,
try this
IF(RowNo()=0, Sum(REVENUE)/COUNT(REVENUE),RangeAvg(Above(Sum(REVENUE)/Count({<MONTH={"=Sum(REVENUE) <> 0"}>} DISTINCT MONTH),0,RowNo())))
Dear Antonio,
Your expression did work which is in the 1st sheet data. I have a 2nd sheet which extract latest Month running total from the 1st table data. when the same formula applied the figures produce are wrong. In this sheet I do not show all the Months but only latest Month data.
Thanks
Neville
Try
Avg(Aggr(Sum(REVENUE),BR_CODE,MONTH))
Dear Antonio,
Your expression is alright. It worked. Could you please suggest me an expression to get the running total to the 2nd sheet from the 1st table. Here again it should be the total of each Branch separately.In other words the cumulative total of each Branch as at Sept.
Regds
Nville
What is Your expected result ?
For RA it should be 680000, for EH 2666667 & for K7 1266667 etc
Like running average , above figures to be brought to the 2nd sheet.
Thanks
Neville
Avg(Aggr(Sum(REVENUE),BR_CODE,MONTH))