prompt values

[Former Member]

Hi,

We have  Material hierarchy variable (MAT_VAR) in BEx query I want to display selected material key value in report.

Below is the material data

Mat	Key
MatA	XYMatA
MatB	XYMatB

I am using below formula to display its key values and it is working fine if user selects single value

="XY"+Userresponse("MAT_VAR")

When user selects multiple values then it is displaying like below:

XYMatA;MatB

But I am expecting XYMatA;XYMatB (in single cell)

Thank you,

suri

[amitrathi239 · Accepted solution]

Hi,

use this.

=Replace("XY"+UserResponse("MAT_VAR");";";";XY")

Amit