Using OFFSET to retrieve prior period data from another module

Highlighted
Previous Contributor

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

1 REPLY 1
Highlighted
Previous Contributor

RE: Using OFFSET to retrieve prior period data from another module

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