@CURRMBRRANGE doubling figure in in alternate week hierarchy
Content
Hi all,
I created an account to aggregate the past values of another account. I have a Period dimension with weeks 1 to 53. I created an alternative hierachy extending the weeks to week 100 I..e Week 1 to Week 100). The formula works well up until Week 53 and then doubles from week 54 inwards.
I am using this formula
@SUMRANGE ("<Account>", @CURRMBRRANGE("Period",LEV,0,,0));
What do you I need to do get this to work properly?
Thanks,
Nathan
Tagged:
0