Current Period vs Manually Input Period

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

Accepted answers

nathan_rudman

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

All comments

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

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!

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…