This content has been marked as final. Show 3 replies
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?