Get the Month from a Switchover W/e Date

sosunkwo
Frequent Contributor

Get the Month from a Switchover W/e Date

Hello all, 

 

How can I get the month where the switchover week-end falls under? I've tried several things, not getting the desired output, yet.  Thanks! 

 

sosunkwo_0-1629837037245.png

 

 

2 REPLIES 2
rob_marshall
Moderator

Re: Get the Month from a Switchover W/e Date

@sosunkwo 

 

Great question...Is it the Current Version or just any version with a switchover?

 

rob_marshall
Moderator

Re: Get the Month from a Switchover W/e Date

@sosunkwo 

 

If it is for just the Current Version, you can change the formula scope to Current Version, but if you want all of them, you can do this:

 

Create a module dimensionalized by Time and Versions, with one line item.  I have it defined as Date, but it could be anything.  Format should be Period with the summary being either First Non Blank or Last Non Blank.  The formula should be: IF ISBLANK(PREVIOUS(Date)) THEN ITEM(Time) ELSE PREVIOUS(Date)

 

2021-08-24_16-06-21.png2021-08-24_16-06-36.png

 

Then, the fun trick is to change the Formula Scope to All Versions except Actual.

 

2021-08-24_16-06-47.png

 

2021-08-24_16-10-44.png

 

Hope this helps,

 

Rob