I can not point out what is the return type of these functions? numeric value or member?
And if they return a member would this fomula be valid (i need to take avg value of march and june):
avgppl = @avgrange("HRsummary" -> "territory",@list(@currmbr("YearTotal"),@shift(@currmbr("YearTotal"),-3)))
The problem with prev and next siblings is the does not work as i want with level 0 time members, so if i need to jump from june to march i can not use siblings fucntions coz they are not siblings and refer to different parents (Qtr1 and Qtr2)