First Year of a month identification

Highlighted
New Contributor

First Year of a month identification

In my Level 2 Supply Chain Lowel Bolin model I have multiple Time Settings module.

 

SYS00 Time Settings by Month

SYS01 Time Settings By Week

SYS02 Time Settings by Year

SYS03 Time Settings by Half Year

 

So, I have question regarding Weeks and Months.   My SYS01 Time Settings By Week has

(Jan)Week 1 FY 20 - 12/29/2019-1/4/2020

(Jan)Week 2 FY 20 -  1/5/2020-1/11/2020

(Jan)Week 3 FY 20 - 1/12/2020-1/18/2020

(Jan)Week 4 FY 20 - 1/19/2020-1/25/2020

(Feb)Week 5 FY 20 – 1/26/2020-2/1/2020

 

I want to be able to identify thru a number (1,0) or Boolean the first week of each Month.  So if using a Boolean I would mark Week 1 FY 20 as True and all other weeks in Jan 2020 as False.  I would then mark Week  5 FY 20 as True and all other weeks in Feb 2020 as False…is this doable?

5 REPLIES 5
Highlighted
Occasional Contributor

Re: First Year of a month identification

You will need to do it in a few LIs

 

Have a LI called Month which is equal to Month(Start()) set to a number in monthly time buckets.  This creates a simple LI with the numeric value of the month in every column.

 

Then make a LI called MonthValue which is set to MONTHVALUE(Month) formatted to a number in weekly time buckets.  This looks up the month value for each week.

 

Then make a LI called Firstweek? which is NOT(MonthValue = Previous(MonthValue))

 

We are just checking to see if the value of the month has changed since the last period, and setting it true in that case.

 

 

Highlighted
Master Anaplanner/Community Boss

Re: First Year of a month identification

Hi @bolinl1 ,

 

Try this method, similar to Jonathan's solution. 

Pic 1.png

 

~Vignesh M

Highlighted
New Contributor

Re: First Year of a month identification

But don't I then have to do this every time I move out another year?  

Highlighted
Master Anaplanner/Community Boss

Re: First Year of a month identification

@bolinl1 

 

Here is another way of doing it.

 

In you SYS Time Week module, create 3 line items (Item, Month, Is First Week?) with the following formulas:

2020-07-23_17-24-34.png

 

On the Item line item, change the summary to First Non Blank

2020-07-23_17-25-28.png

For a result of:

2020-07-23_17-26-33.png

 

 

OR, you could do it the other way, from the SYS Time Month module:

 

2020-07-23_17-30-55.png

 

2020-07-23_17-31-34.png

 

 

 

Hope this helps,

 

Rob

Highlighted
Master Anaplanner/Community Boss

Re: First Year of a month identification

@bolinl1, No you don't have to set this every year. All the provided solutions are dynamic and it doesn't require any setup.