Thank you in advance for your help. I am very stuck.
I have a variable set up as an expression which accepts a numeric value as a parameter and returns a string with a viable set expression:
The call is:
$(vAtest([RowDimension]))
where vAtest is defined as:
'=count({State' & $1 &'}OwnerID)'
I have 6 states defined as State1, State2, ... State6
Everything works as expected if I just view the string in a row as the return of the call, but when I try to call the function to be evaluated as an expression it doesn't pick up RowDimension, returning count({State}OwnerID) which is 0 (there is no state called 'State').
Here is the call for Returned String:
$(vAtest([RowDimension]))
Here is the call for value:
$(=$(vAtest([RowDimension])))
I can hardcode the parameter and it works correctly, e.g.:
$(=$(vAtest(1)))
Thank you for any help