Range Sum

[Anonymous]

Hello,

I have the data like this.

TurnOver= Readmission/admissions

July TurnOver= Readmission/admissions

August TurnOver= July Turnover + August TurnOver / 2

Sept Turnover = July Turnover + August TurnOver +Sept Turnover / 3

This is how the calculation should be. If I'm selection only July it should take  only 1month turnover and If making selection as August then it should take Avg of July and August Turnover.

Please help. Urgent requirement. stalwar1‌ mto‌jagan‌

Fiscal Month	Gender	% Turnover	Readmission	Admissions
Jul	Female	1.3%	184	14452
Jul	Male	1.0%	207	20262
Aug	Female	1.0%	142	14553
Aug	Male	1.0%	206	20374

[Anonymous]

Dimension: Month

Expression:

RangeSum( Above( sum( Readmission) /sum(admissions) ,0,rowno()))/rowno()

[Anonymous]

Out put would be:

Jul	Female	1.3%
Jul	Male	1.0%
Aug	Female	1.2%
Aug	Male	1.0%

[Anonymous]

akka.. What is row () here...? Rajitha here

[sunny_talwar]

I am getting this

Expression:

=Aggr(RangeAvg(Above(Sum(Readmission)/Sum(Admissions), 0, RowNo())), Gender, [Fiscal Month])

[Anonymous]

Bro, I have one calculated Dimension for Gender =IF(GENDER='Unknown',Null(),GENDER)

My actual expression is= 

(sum({<GENDER_DETAIL-={'Elected*'}>}VOL_TO_INDICATOR)

/

(count({<GENDER_DETAIL-={'Elected*'}>}FTE)))

Please correct me If I'm wrong, Final expression which I changes to is :

=Aggr(RangeAvg(Above(sum({<GENDER_DETAIL-={'Elected*'}>}VOL_TO_INDICATOR)

/

(count({<GENDER_DETAIL-={'Elected*'}>}FTE)), 0, RowNo())),

IF(GENDER='Unknown',Null(),GENDER), [Reporting Month])

Please advise, how to write it. The above one is not working for me according to ur logic.

stalwar1‌

[sunny_talwar]

Aggr cannot take in calculated dimension, have you tried with just this?

=Aggr(RangeAvg(Above(sum({<GENDER_DETAIL-={'Elected*'}>}VOL_TO_INDICATOR)

/

(count({<GENDER_DETAIL-={'Elected*'}>}FTE)), 0, RowNo())), GENDER, [Reporting Month])

[Anonymous]

The august Female turnover is showing 1.0% instead of 1.1%

[sunny_talwar]

It would be difficult to say anything unless I see. Also, you are just comparing upto 1 decimal? Have you looked at the difference when we have lets say 4 decimals? May be the difference is rounding.

You are getting 1.051 and the solution might be giving 1.049.

[rahulgurram · Accepted solution]

Hi Vinay,

Try this if you are still working on this issue

(rangesum((sum({<GENDER_DETAIL-={'Elected*'}, GENDER = {'Female'}>}ReAdmissions)/(count({<GENDER_DETAIL-={'Elected*'}, GENDER = {'Female'}>}FTE))),Above(Female)))

/(rangesum(above((count(Distinct {<GENDER_DETAIL-={'Elected*'}>}FISCAL_MONTH))))+1)

Thanks