Forum Stats

  • 3,854,962 Users
  • 2,264,441 Discussions
  • 7,905,847 Comments

Discussions

Intersect of Month with a month range

Teresa Modesta
Teresa Modesta Member Posts: 313
edited Jun 5, 2018 5:06AM in Planning and Budgeting

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?

Tagged:

Best Answer

Answers

This discussion has been closed.