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

       

      vWeeklyMonthly

       

      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