Why not just use the [5YF Avg UO Rental Growth] --
the Average of 5YF Averages -- as a RefLine?
Do the numbers of 3.5% for 2016F or 3.6% for 2017F look good for you?
If not, what the expected values would be, and more important,
what the underlying calculation / filtering logic would be?
Hi Yuriy, thank you for your reply.
I would like to use weighted average (rental growth * no. of beds in each market) which is pre-calculated under 'USA' in my data. If I use Average of 5Y averages, I get a simple average (3.48% and 3.65% for 2016F and 2017F). But yes that would change with years automatically. Is there maybe a hack to set up a parameter with an equation? Or set up a reference line with filters/equation?
Expected value for 2016F Rental Growth Ref Line: 3.43% i.e. USA, filtered to 2016F
Expected value for 2017F Rental Growth Ref Line: 3.64% i.e. USA, filtered to 2017F
The difference isn't big here because of a largely homogenous sample. But I can imagine scenarios where weighted average and simple average yield significantly different results.
2 of 2 people found this helpful
Since I couldn't reconstruct the [UO Rental Growth]
USA values from the States figures, I just pushed
the USA values (already in the dataset) to each State
(using FIXED & EXCLUDE LOD combo).
Please find the attached.
Hope it would be of help.
Thank you Yuriy! This works perfectly for Rental Growth!
I duplicated your FIXED & EXCLUDE LOD for Occupany Change but can't figure out why I'm not getting the expected results as in 'UO Occ' tab? I seem to be pulling up Avg Occ Chg of one year only despite doing Window_sum for 5Y?
Please see attached.
Your help in troubleshooting is much appreciated.
1 of 1 people found this helpful
What are the expected results for 2016F and 2017F?
If they're like -0.06% and +0.07% respectively, then you'd like
to set the [YF : Weighted OC] Table Calc Pill on Details
to be Addressing along (Compute using =>) [Year] --
just the same as for the [YF : Weighted RG] table calc pill.
Hope it could help.
Thank you, Yuri! This solved the issue!! And I learnt something new
Jingwei, you're welcome.