Level 2 - Sprint 2 YEARVALUE formula for Model Calendar and Time Ranges gave different results

In the following two examples, the difference is the Time Range applied - Model Calendar vs FY19-FY20

The results are as follows:

1) 1st Forecast Year? - Model Calendar - Tick-marked for Weeks for FY20

2) 1st Forecast Year? Test2 - FY19-FY20 - None tick-marked for all time periods. Refer to purple box below.

I was expecting '1st Forecast Year? Test2' to be tick-marked for periods in FY20 .......similar to point (1). What's the logic for none tick-marked for all time periods?

Comments

Sathya M

Hi @Star,

Can you please send the screenshot of the "Time Ranges" (FY19-FY20).

Thanks

Sathya

johndorma

In the first example, you reference the current period line time which has a summary on so there is a value at the year summary. It appears in the second example you have a current period test 2 line item which does not have a summary on and therefore no year value is available or returned in the formula.

Star

@johndorma

For year summary, are you referring to the column in the orange box below?

johndorma

Correct. In the second screenshot, you are referencing a line item that does not have a summary on so it does not have a value to grab using the YEARVALUE() formula. I've included an example. I may have misunderstood the question though, if you're are looking to mark every period as true no matter what, you can just make the formula "TRUE".

Star

@johndorma
Thank you 🙂

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…