Skip to Content
Former Member
Jan 30, 2017 at 04:35 AM

Multiple Vales to PROMPT for BEx Variable, List Selector Box



We have a requirement for a user to select any number of FYs from List Selector and pass these values to a cell acting as prompt input. Backend is a BEx query ( variable with multiple single values ). Using concatenate with values seperated by ";" we have capture the selection to a cell. But it gives error as non selected years give the result like this : A;B;C;;;;;.

How to handle this that the concatenation is correctly formulated ?

warm regards,