02-06-2012 03:24 PM
I've made a prompt (drop down format) where the user selects from a list of text values, I would like to use the TEXT VALUE that the user chooses in a computed column. As an example, I would like to simply return the text value the user has chosen as a computed column. I tried: &promptname and it errored out. I was trying to call the value like the filter does when it calls the value of the prompt. I'm sure this feature exists.
In short: How do you call a prompt value in an advanced expression in a computed column?
02-06-2012 03:44 PM
You can use the macro variable created by the prompt ... which I don't think that will mean much to you.
Can you give me an example of how you are using this ... for instance, the user picks a word (like Dog) or a value (like 4) and then your computed column would output something like this:
"You picked: Dog"
or this "100" (because 25*4 is 100)
02-06-2012 04:01 PM
Well the trick seemed to be use quotations. The user selects a string. I tried to report the string by doing &promptname. I tried '&promptname' and that returned "&promptname". Then I tried double quote "&promptname" and that returned the selected prompt value that I was looking for. Very odd behavior from double quotes, that's usually reserved for designating text. I appreciate your response!
Need further help from the community? Please ask a new question.