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
Tagged:
0
Best Answer
-
If the offset function doesn't work you can try using the lag function.0