In a previous post I asked a fairly difficult to understand question but looking at the question and the responses it occured to me that the problem (and the answer hopefully) are simpler:
I have a variable that contains the following definition:
{$<MonthID = {">=$(=min(MonthID) - 12)"},
Date = {"<$(=Date(MakeDate(Year(Max(Date))-1, Month(Max(Date))+1, 1),'DD/MM/YYYY'))"},
Year = ,
Quarter = ,
Period = ,
[Period (#)] = ,
Month = >}
I need to modify if to:
a) Remove the dependency on Date (line 2)
b) Extend the MonthID line (line1) to also include "< max(MonthID) -11"
Conceptually it will look something like:
{$<MonthID = {">=$(=min(MonthID) - 12)"} and {"<$(=max(MonthID) - 11)"},
