CONCATENATE operation with thousand separator

Hello @knuthbecker

You have forgotten a comma in the code. The correct would be:

CONCATENATE('Between ', fieldname2*500, '-', fieldname2*650, 'USD')

For decimal separator, you can use the FORMAT operation:

CONCATENATE('Between ', FORMAT(fieldname2*500, {groupingsymbol:','}), '-', FORMAT(fieldname2*650, {groupingsymbol:','}), 'USD')

Best regards.