Current Period vs Manually Input Period

Options
michaelna
michaelna Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

I'm seeing some unexpected behavior in a Lookup formula that is referencing a period formatted line item. When I manually select a value for Current Year, my lookup formula performs as I expect it to. However, if I enter TIME.'Current Period' in Current Year, it shows the expected year in the line item, but my formula doesn't recognize it. Can anyone explain what is happening?

 

Manually selected:

michaelna_0-1619529885416.png

Yeilds expected result:

michaelna_1-1619530046804.png

Coding Current Year:

michaelna_2-1619530080765.png

Filter formula no longer gives the expected result:

michaelna_3-1619530177754.png

 

Thank you,

Michael

Tagged:

Comments

  • michaelna
    michaelna Member, ALL USERS Posts: 2 New Contributor

    My model uses a weekly calendar, so I suspect you are right and it's returning a week period. PERIOD(CURRENTPERIODSTART()) got me the results I needed.

     

    Thank you both for the insights!

Categories