Below is my requirement-
I have a report with Bex as backend. I have a selection variable "Installer" it displays the text.
and also when these prompt values are captured using user response it displays the text.
For certain technical constraints BW team will not be able to add a characteristic in to the query, so that I can get the key for the Installer.
the prompt values are also minimal -- 6 values
Now my requirement is to capture these text and display keys in the report
I used below formula to display keys. which did not work when multiple values are selected.
=If Match([Installer selected];"*Not assigned*") Then "#"
Else If Match([Installer selected];"*Domestic*") Then "Y1"
Else If Match([Installer selected];"*Commercial*") Then "Y2"
Else 0
Please suggest.