Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

display prompt values in report

Hi,

We have variable 'Test(X_TEST)' in BEx and when user selects values in prompt then I want to display its key values (Not Text) in report.-

it is displaying its text with Userresponse("X_TEST"), so i tried something like below.

=If(Userresponse("X_TEST")="TextA";"1001";If(Userresponse("X_TEST")="TextB";"2001"))


Above formula is fine if user selects single value, but user can select multiple values with any combination. So could you please help me how to handle this to display key values.

Thank you,

Suri

Former Member
Not what you were looking for? View more on this topic or Ask a question