You could create a variable, for example vDivisor, defined as: =getfieldselections([BUD01.Divisor])
When you select a single value in the BUD01.Divisor field the variable will change to that field value, so you could write your expression as:
sum(TOTAL PeriodBalance * $(vDivisor))
Just tested on version 11 but should be fine for v9 too.
Thanks very much for the reply, Johannes
That works when a value in BUD01.Divisor is selected, but we can't do that since it is used in a column in a 40+ line report (Straight Table), with each line having a potentially different Divisor.
I'm attaching a sample of the report, adding BUD01.Divisor and BUD01.Divisor Amount for illustration.
Thanks for any help.
The problem is that when you use the variable expansion ($(=....)) QV looses the context.
Try to put ='$(=concat(BUD01.Divisor))' in an expression and you will see that QV concats all divisor not only the current one.
And unfortunately the Evaluate function works only in script.
I will follow the subject because I'm curious of a solution but I have not a lot of hope.