Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Or, if you have a variable as you mention, simply Sum([$(vCurrentYear) Sales])
May be something like this -
=Sum($(='['&Max(Year)&' Sales'&']'))
Or, if you have a variable as you mention, simply Sum([$(vCurrentYear) Sales])
This works perfectly thank you