Skip to Content
avatar image
Former Member

prompt values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 16, 2015 at 09:30 AM

    Hi,

    use this.

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

    Amit

    Add comment
    10|10000 characters needed characters exceeded