display text value - alternative to sum()

[#1]

usually, text values are displayed by just  =(fildname)

if certain expressions are used, this doesnt seem to work.

Is there an alternative to the "sum" operator ?

sum(CustomerID) results in "-", because CustomerID='AX001FE' ; alphanumeric.

- text(), treats numeric values as txt similar to num()

- there is minstring or maxstring, but no string()

is there an alternative to display

<operator>({<[Tablename]={'GroupA','GroupB'}>}CustomerID) ?

any suggestions are welcome

[CELAMBARASAN · Accepted solution]

Hi,

     Have you tried using Concat Function?

     Concat(({<[Tablename]={'GroupA','GroupB'}>}CustomerID,',')

Celambarasan

[#3]

thank you Celambarasan. This is exactly what solves this (and some other) problems.

The full text search in the reference manual found only text(), which f.e. as the opposite of num() only changes the output of a expression (if applicable) to text form.