Adding a variable as part of an exporession

[#1]

Hi All,

I'm trying to use a variable as part of field name in an expression but not having much luck:

So, my list box(can only select single item) is:

Year1

Year2

Year3

And my expression:

=Sum(YearlyPerf.$)

where $ is either a the variable extracted from the listbox. e.g. YearlyPerf.Year1

Any ideas?

Jamie

[#2]

Do you already have a variable which is returning the proper selection?

If so, you should use:

Sum($(vVariable))

[#3]

Hi Jamie,

Firstly create a variable vYr then add an input box and select vYr on the constraints tab select predefined values in a dropdown box then tick listed values. Add Year1;Year2;Year3 This is exactly what the field is called.

Your expression should be =Sum(YearlyPerf.$(vYr))

The $ expansion should then put in the fully qualified field and work in the expression.

Regards,

Neil