Highlighted
Regular Contributor

First period of the years - Boolean

Hi

For a line item (Boolean format), what function can be applied to tick-mark if it is the beginning period for each of the years?

E.g.  Week 1 - FY20               Jan 20 - FY20

        Week 1 - FY21               Jan 21 - FY21

        Week 1 - FY22               Jan 22 - FY 22

So, if it is 'Week 1' or 'Jan' for each of the years above, then it should be 'TRUE' and tick-marked

 

 

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: Level 2 - Sprint 3 First period of the years - Boolean

Hi @Star,

 

Please try this formula --> ITEM(Time) = TIME.'Current Period'. 

                       Summary --> Any

The Time Scale should be 'Week' for that Boolean formatted line item.

 

Thanks

Sathya

Highlighted
Certified Master Anaplanner

Re: Level 2 - Sprint 3 First period of the years - Boolean

Hi @Star

 

To determine the first MONTH of each year (timescale set to month), I would recommend using a boolean formatted line with a formula along the lines of MONTH(ITEM(Time)) = 1.

 

To determine the first WEEK of each year (timescale set to week), it is a little tougher. I would translate the week into a year so the line item would say FY18 for every week until reaching FY19 and then say FY19 for the 52 weeks. Then, you could have another line item that says if Year line item > Previous(year line item) then TRUE (i.e. would work out to say IF FY19 > FY18 THEN TRUE).

 

Kathleen