Running average needs to be specific for each Branch code

[nevilledhamsiri]

Hi Guys,

Could you please guide me to fix the running average (Net claims) for each BR Code separately. In other words after seven months the total row should carry the average total &  for the next Branch it should start again from the Jan figure of the said Branch etc.

Thanks

Neville 

[sunny_talwar]

Try this

RangeAvg(
	Above(
		Sum({<DESCRIPTION = {'NET CLAIM'}>} MONTH_ACT)
	, 0, RowNo())
)

[nevilledhamsiri]

Thanks sunny, That is fine. Also will you suggest how I get the total row arranged in total average. Right now it is in blank. If Aggr to bring in how the string to be arranged. Eg  AS Total should be Rs 3,003,852

Thanks

[sunny_talwar · Accepted solution]

This

Sum(Aggr(
	RangeAvg(
		Above(
			Sum({<DESCRIPTION = {'NET CLAIM'}>} MONTH_ACT)
		, 0, RowNo())
	)
, BR_CODE, TRN_MONTH))

[nevilledhamsiri]

Thank you very much. It provided what I looked forward to

Neville