topic Re: Using a Variable in a Field Name in an Expression in App Development

Using a Variable in a Field Name in an Expression

m_perreault — Sat, 16 Nov 2024 08:35:37 GMT

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!

Re: Using a Variable in a Field Name in an Expression

Digvijay_Singh — Tue, 06 Mar 2018 23:31:07 GMT

May be something like this -

=Sum($(='['&Max(Year)&' Sales'&']'))

Re: Using a Variable in a Field Name in an Expression

juraj_misina — Tue, 06 Mar 2018 23:51:31 GMT

Or, if you have a variable as you mention, simply Sum([$(vCurrentYear) Sales])

Re: Using a Variable in a Field Name in an Expression

m_perreault — Wed, 07 Mar 2018 00:06:19 GMT

This works perfectly thank you