@PRIOR using @XRANGE not crossing year on calc script first run
Hello,
Calc script to roll forward values (Ending Bal to Beg Bal) requires running it twice to produce values for the next year. You can see the commented out @MDSHIFT that I tried to handle the "2020"->"Jan" combination, but it still required a second run of the calc script. Can't seem to get around having to run the script twice. The fact that it works the second time is why I can't understand why it doesn't the first time through.
BSO Cube Dims:
Company (Sparse)
Scenario (Sparse)
Year (Dense) - 2019, 2020 (Ascending)
Period (Dense) (Time) - Jan, Feb, Mar,...,Dec (Ascending)
0