FIX(&CurYr, @LEVMBRS(Period,0))
"HeadCount"
(
IF(@ISMBR(Jan))
HeadCount = @MDSHIFT("HeadCount",-1,Year, ,11,"Period",) + New;
ELSE
HeadCount = @Prior("HeadCount", 1) + "New";
ENDIF
)
ENDFIX
@MDSHIFT抓Outline上成員的相对位置, Year 维度上抓前一个成員, Period 抓11个成员 (Dec)
"HeadCount"
(
IF(@ISMBR(Jan))
HeadCount = @MDSHIFT("HeadCount",-1,Year, ,11,"Period",) + New;
ELSE
HeadCount = @Prior("HeadCount", 1) + "New";
ENDIF
)
ENDFIX
@MDSHIFT抓Outline上成員的相对位置, Year 维度上抓前一个成員, Period 抓11个成员 (Dec)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7477027/viewspace-630053/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7477027/viewspace-630053/