ChangeHardcoded in variable

[#1]

=((

SUM({1<Budgetscheiding ={'Detailhandel'}>} AantalHuidigJaar)-SUM({1<Budgetscheiding ={'Detailhandel'}>}AantalHuidigJaarMin1))/SUM({1<Budgetscheiding ={'Detailhandel'}>}AantalHuidigJaarMin1

))

How can i change te hardcoded words Detailhandel in the Variable test.

Thanks,

[#2]

Are you trying to create a variable test and use that to store the desired value for Budgetscheiding?

Is so, create the variable and give it a value. Then use:

=((SUM({1<Budgetscheiding ={'$(Test)'}>} AantalHuidigJaar)-
SUM({1<Budgetscheiding ={'$(Test)'}>}AantalHuidigJaarMin1))/
SUM({1<Budgetscheiding ={'$(Test)'}>}AantalHuidigJaarMin1
))

[#3]

Thanks for the quick reply.

Greetz,

Dirk