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 ?