9 Replies Latest reply: Oct 14, 2011 11:06 AM by zack.lore RSS

    Triggering a macro on the evaluation of an expression variable

      Hi All,


      I need a document variable event 'on change' trigger to run a macro, my problem is that the variable is an expression, the triggers only seem to work when the actual value contained in the variable changes.


      this is my variable




      which contains


      =if(GetCurrentField(date_dimension) = 'Week Ending','Weekly',if(GetCurrentField(date_dimension)='Month Year','Monthly'))


      I need to trigger my macro when the expression in the variable changes from 'Monthly' to 'Weekly' or vice versa.


      does anyone know how to achive this?


      Thank you