How to post a Month from current year to previous year

shadmani
shadmani
in Modeling

Hi, 

 

I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year .

 

Module is by Year dimension .

for example - I select FY 20 as dimension 

Line item -entry is jan 19 ,

Result - Want to post jan 19 in Jan 19 (though I input in FY 20 as dimension) 

 

Post /lag works only on number . 

 

Thanks in advance !!

Tagged:

Best Answer

  • jasonblinn
    jasonblinn
    Answer ✓

    I am not sure that I follow the question completely, but it seems like the following achieve your ask:

     

    I have my Input Module, which as you eluded to is dimensionalized by Year, and I enter Jan 19 in FY20

    jasonblinn_0-1602826229322.png

     

    In my output module, I have 2 lines:

    jasonblinn_1-1602826316707.png

     

    My Line item Formula Shows that:  If the input from the first screenshot of the next year = the time period then display the time period. IF Input[LOOKUP: Year] = ITEM(Time) THEN Input[LOOKUP: Year] ELSE BLANK

    The Year line item would be better suited in a Time Setting Systems module but wanted to put it here to make the screenshots more concise. This just takes the current year and adds 1 so that we get next year as the result. 

     

    As you can see, I select Jan19 in FY20 and See Jan 19 in Jan 19 now.

     

    jasonblinn_2-1602826494717.png

     

    If I Change FY20 Value to a different month, then it appears in the corresponding month. 

    jasonblinn_3-1602826551987.png

     

    Let me know if this isn't what you are looking for.

     

    Thanks,
    Jason

Answers

Categories