Alternate States - Field Event Triggers

[#1]

Hello,

This is my inline table:

TimeExpressions, TimeYear, TimeMonth

Year over Year, sYearOn, sMonthOff

Month over Month, sYearOff, sMonthOn

Custom State, sYearCustom, sMonthCustom

These are the Variables:

SET sYearOn =             =max({<Year=A::Year>} Year)-1

SET sYearOff =             ='=sum({<Year=A::Year>}1)'

SET sYearCustom =     ='=sum({<Year=B::Year>}1)'

SET sMonthOn =           =max({<Month=A::Month>} Month)-1

SET sMonthOff =           ='=sum({<Month=A::Month>}1)'

SET sMonthCustom =   ='=sum({<Month=B::Month>}1)'

I have 2 Alternate States, "A" and "B". Each state has its own Year and Month list box.

I also have a "TimeExpressions" list box I created in the Inline table. (Make sure to set the TimeExpressions list box to Alternate State "A")

Under Field Event Triggers located at : Settings->Document Properties->Field Event Triggers->Year Field & Month Field

For the Year Field Event Trigger I set:

OnSelect->Edit Actions->

Actions :                Select in Field

Field :                     Year

Alternate State :     B

Search String :      =$(=TimeYear)

For the Month Field Event Trigger I set:

OnSelect->Edit Actions->

Actions :                Select in Field

Field :                     Month

Alternate State :     B

Search String :      =$(=TimeMonth)

The way this works is when I select values in the list box called "TimeExpressions". I can click on Year over Year and all my values from State "A" Year and State "A" Month are transfered to State "B" Year and State "B" Month, minus 1 year.

It works the same way with Month over Month but the Year stays the same and the Month goes back 1 month.

The issue is with the Custom State Selection, I'd like it to simple stop transfering the values from State A to State B and allow me to click my own custom field values in State B.

What's odd is this:

SET sMonthOff =           ='=sum({<Month=A::Month>}1)'
(This copies the same value from State "A" Month to State "B" Month,

SET sMonthCustom =   ='=sum({<Month=B::Month>}1)'

(This SHOULD copy the same value from State "B" Month to State "B" Month, or leave it the same, when I place this value directly into the Field Event Trigger without a variable it works!)

Is there a different syntax I can use to disactive this and allow me to select my own values from State B again? instead of   " ='=sum({<Month=B::Month>}1)' "     

Any suggestions would be much appreciated.

I've attached a simple QVW of all of this put together.

Thank you