@RELXRANGE not working when argument is @XRANGE with cross-dim members
Summary
@RELXRANGE not working when argument is @XRANGE with cross-dim membersContent
Hi all, frustrated because @RELXRANGE not working as documented.
From @RELXRANGE documentation:
Generates a cross-dimensional list for each cell in the predefined cross-dimensional list (XrangeList), based on the relative position of the cell that is currently being calculated and the offsets, using the predefined cross-dimensional list (XrangeList) as the limit.
Example from the documentation:
mbrCount=@COUNT(SKIPNONE,@RELXRANGE(-1,3,@XRANGE(Jan->Actual,May->Actual))->Sales);
Used in either a member formula or in a calc manager rule, this returns #Missing :
Tagged:
0