Refer formula across modules with different time range

VSekar
VSekar
in Modeling

Hi, 

 

I have two modules named A and B. In module A, my time range is FY17 & FY18. And in my module B, the time range is FY18 & FY19. The fiscal year in my model is Jan to Dec. Now I want to refer the data of FY17 from module A to FY18 of module B. I have tried with Lag, lead and offset. But all these have the restriction as 'The time range providing arguments to a line item must match the time range for the result line item;. When I use Previous function, it is working fine. But I am getting result only for Jan18 from Dec17 with previous function. My requirement here is that I need to get the old year complete data from module A of FY17 to Module B of FY18. 

 

Can you please help me? 

 

Tagged:

Best Answer

  • VIGNESH.M
    VIGNESH.M
    Answer ✓

    Hi,

     

    Try this,

    Step 1: Create a line item(Previous Year) in the Target Module and format it as Time Period.Month Format and Use the below formula

    001.png

    Step 2: Write the logic to pull data from Source to Target Mod, use the formula highlighted below

    1.png

     

    Note: Keep the previous year line item in a separate system mod.

     

    Regards,

    Vignesh M

Answers

  • DavidSmith
    DavidSmith

    @VSekar 

    And just to add, in the Time Settings module, the simplest formula to calculate the previous year month is 

     

    ITEM(Time) - 12 in a line item formatted as Month

     

    no need for any Text extractions and re-joins.

     

    David

  • VSekar
    VSekar

    Hi Vignesh & David, 

     

    Thank you for your reply. It was helpful and resolved my issue. 

Categories