Have a module where Time is not a dimension, we have system created list to be used as year, and there is a line item where we need to get the ending balance as the opening balance in another line, which formula can help us attain that?
In the below screenshot, we need to get the numbers of last line as the opening of next year.
As other champs have mentioned this usually is achieved with the help of LOOKUP but if you are running it in a loop you will get circular references. Hope you are not referring the same line item (Line item B) where you are writing the formula.
Formula should be like :
Line item B = Line item A[LOOKUP: SYS Mapping Module. Mapping Line item] - this should give you the previous year's value if the mapping is done accordingly.
If all this doesn't work then I would say convert the module into Native Timescale dimensioned module and use Time based Functions & then reconvert the module back into Custom Time dimensioned module - Not an ideal solution but indeed the last resort for you,