3 Replies Latest reply: Mar 6, 2018 7:06 PM by Mark Perreault RSS

    Using a Variable in a Field Name in an Expression

    Mark Perreault

      Hello,

       

      The data I am working with has fields broken down as '2018 Sales' and '2017 Sales'.  I would like to create a variable for current year and use it in my field name within an expression.  For example if my variable vCurrentYear =  max(Year) I would like to be able to use an expression along the lines of  sum("$(vCurrentYear) & Sales") to give me the sum(2018 Sales).  Does anyone know if this possible and how to do it?

       

      Thanks!