Dear specialists,
I am trying to use a variable to determine which data I have to use in my expression.
See the attached document for an example.
In this example I got on the right side the outcome how I want it to be.
But there I am using a large IF(..)-function like: IF (Keuzelijst1.Keuzelijst1 = 'Been', (Sum(Been)), IF (Keuzelijst1.Keuzelijst1 = 'BMI', (Sum(BMI)), IF (Keuzelijst1.Keuzelijst1 = 'Buik', (Sum(Buik)), IF (Keuzelijst1.Keuzelijst1 = 'Calorieën', (Sum(CalWeek)), IF (Keuzelijst1.Keuzelijst1 = 'Heup', (Sum(Heup)), IF (Keuzelijst1.Keuzelijst1 = 'Gewicht', (Sum(Gewicht)), IF (Keuzelijst1.Keuzelijst1 = 'Vet%', (Sum(Vet%)))))))))
I want to get rite of this because it isn't flexible at all.
To accomplish this I made 2 inline tables with the names of the fields I want to use in my expression. And 2 variables that display the selected field.
What I want is to use the result as this:
SUM('variable') (in my case SUM(vKeuze1) or SUM('vKeuze1'))
Is this possible?
And if so, how? Thanks. | 
