Current Period vs Manually Input Period

[michaelna]

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:

Yeilds expected result:

Coding Current Year:

Filter formula no longer gives the expected result:

Thank you,

Michael

[obriegr]

Michael,

Are you using different time ranges?

Do you have the settings set correctly on Summary for the target (I assume so, as the first time it worked, but best to double check)?

It is possible that on the backend, that Anaplan is returning Jan. 1st, 2021, versus FY21. Have you tried PERIOD(START()) formatted as Year?

Michael,

Are you using different time ranges?

Do you have the settings set correctly on Summary for the target (I assume so, as the first time it worked, but best to double check)?

It is possible that on the backend, that Anaplan is returning Jan. 1st, 2021, versus FY21. Have you tried PERIOD(START()) formatted as Year?

Are you using time with the module, and therefore it is not summarizing correctly?

[nathan_rudman · Accepted solution]

Time.Current Period must be returning a Month formated Period format.

So get this in a LI that is Month formated and then get the year

Or do PERIOD(currentperiodstart()) in your year line item

[michaelna]

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!