Using OFFSET to retrieve prior period data from another module


Hello, I am attempting to retrieve prior period data from module 1 to module 2 and cannot seem to get the OFFSET function to work.  However, when  I use OFFSET to retrieve data from module 2 (same source and same target), the function works. What am I doing wrong? This Works in Module 2, Line Item Calc OFFSET(Entry,-12,0) This Does not Work in Module 1, Line Item Calc OFFSET(Module 1.Entry,-12,0) Thank you

Best Answer

  • PrevContributor
    If the offset function doesn't work you can try using the lag function.