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

Highlighted
Regular Contributor

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

Hi

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

 

Star_0-1587215329918.png

 

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?

 

Star_1-1587215585422.png

 

 

5 REPLIES 5
Highlighted
Certified Master Anaplanner

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

Hi @Star,

 

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

 

Thanks

Sathya

Highlighted
Certified Master Anaplanner

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

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. 

Highlighted
Regular Contributor

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

@johndorma

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

Star_0-1587392272975.png

 

Highlighted
Certified Master Anaplanner

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

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".

 

 

johndorma_0-1587393998060.png

 

Highlighted
Regular Contributor

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

@johndorma
Thank you 🙂