The syntax of book functions is quite confusing. Id check that. Otherwise You can technically run your parameter in a loop, however, nest an if statement within the loop and only allow the selection you want in your scaling parameter to pass. Ive done this on one of my books (out of laziness adapting it from another rather than building a new book!) And it gets round having to set up unique CVs without the Parameters.
Good luck!
Thanks for your response, Thomas.
I have tried it, still it is prompting for selection.
Thanks,
Gayathri.N
Ive always wrapped the loop variables in square brackets try [|Loop1Variable|] = [In Millions]
Thomas, after using square brackets also it is prompting for selection.
