Skip to Main Content

Analytics Software

Intersect of Month with a month range

Teresa ModestaJun 4 2018 — edited Jun 5 2018

Hi,

I have a variable LiveMonths. This contains a range of months, which can be any month to December like this; - "Mar:Dec"

I have a business rule which executes subtly different logic for each month in the year.

I want to use fix statements to ONLY run months in the LiveMonths range.

Is it possible to do the equivalent of, where LiveMonths is set to be "Jul:Dec"; -

/*

this would not fix on any data

*/

Fix(Jan  Intersect &LiveMonths)

Endfix

/*

this would not fix on any data

*/

Fix(Feb  Intersect &LiveMonths)

Endfix

/*

this would not fix on any data

*/

Fix(Mar  Intersect &LiveMonths)

Endfix

... and so on ... down to

/*

this would fix on JUST July

*/

Fix(Jul  Intersect &LiveMonths)

Endfix

/*

this would fix on JUST August

*/

Fix(Aug  Intersect &LiveMonths)

Endfix

Note, this is PBCS and months are dense.

Is this possible?

This post has been answered by user11440683 on Jun 4 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2018
Added on Jun 4 2018
8 comments
254 views