on 10-16-2015 9:53 AM
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
Hi,
use this.
=Replace("XY"+UserResponse("MAT_VAR");";";";XY")
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.