4 Replies Latest reply: Jun 13, 2014 1:08 PM by Tim Roy RSS

    Variables in Column Label not working.

    Tim Roy

      Hello All,

       

      I have a dynamic label expression that works when It is dropped as is into a straight table column label like so:

       

      =Date(MonthStart(AddMonths(Max((RDateofPmnt),-11),'YYYY-MM'))

       

      However, when I use variables to store the expression, broken in 2 so I can insert a column specific offset number, it does not

      work:

       

      $(=(var1 & '-11' & var2))

       

      I have tried several alternatives but no luck.

       

      When I use a similar tactic for expressions and conditions, it does work.

       

      Just the Label expression does not.

       

      Thanks for any help.

       

      Tim Roy