Using a variable to hold part of a variable name to use in an expression

[#1]

Hello

I have a set of numeric columns:

Buildings Incurred

Contents Incurred

Other Incurred

I have a variable called polsection and it contains the first part of the variable name, e.g. "Buildings", "Contents", "Other"

I want to write a table expression that joins this variable to a string to create the full variable name and sums the value of the field.

I've tried

=sum(=$(polsection)&' Incurred')

and

=sum([$(polsection)&' Incurred'])

and every other combination of symbols I can think of.

Is this even possible? If so how do I do it?

Many thanks!

[Miguel_Angel_Baeyens]

Hi,

Yes, that should work, and you are very close:

Sum([$(polsection) Incurred])

Hope that helps.

Miguel

[MayilVahanan]

Hi

Try like this

variableName

its value ='Buildings'

Then in expression

Sum($(polsection) Incurred)

Ex:

PFA

[#4]

Thanks Mayil

The only other issue is that I want the variable value (='Buildings', ='Contents', etc...) to be selectable in a list box. So I'm trying to use a trigger on list box selection to put the value into a variable, but I don't know how to put ='Buildings' into the variable.

Do you know how to do this?

Thanks.

[#5 · Accepted solution]

Try the function  Getfieldselection

For example variablename  =GetFieldSelection (ListBoxName,',')   in the Variable Overview..