Is there anyway in QuickSight to concatenate numbers with strings while keeping the number format? For example concatenate 1,256.23 and ‘USD’ to show ‘1,256.23 USD’. TRied toString function, but it doesn’t define the format.
if you concatenate, then the field become string. But you may change the field format to be currency and define the format
you might want to try using parerInt() after the concatenation. that will change the type to number so that you can change it to Currency and define format.