BusinessObjects Board

Repeat a value in the same cell

Hi all,
I’m trying to build a report and I have multiple route codes that I want to display in the same cell with a separator, is that possible. Sometimes there may be 3 or 4 route codes to a customer so it needs to be able to handle that many at once. Does anyone know a solution please. I’ve tried the previous function and other various functions but can’t get it right.
Below shows the 2 lines in the report and the original crystal report I’m replicating.

This link should help: String aggregation on WEBI report level. - SAP Community

Or this one: https://web.archive.org/web/20190216052107/http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html