fccs,@SHIFTSIBLING

Feb 24, 2019 4:37AM

Summary

FCCS - How to reproduce @SHIFTSIBLING in FCCS

i know that is not allowed to use this function in fccs, but i need to sum a range of members from x to y, so could you guys help me to reproduce it?

for example:

"Accountx" = @SUMRANGE("AccountY", "variable1":

@MEMBER(@CONCATENATE("Period ",(@SUM(@SUBSTRING("variable1",7),12)))));

variable1 = "Period 100"

i would like to sum the range from Period 100 to Period 112, this functions above doesnt work, and i dont get another idea;