How to Combine Text and Number but Retain Thousand Separator ( , )
i would like to combine text and number but retain the thousand separator, i'm able to add the thousand separator with just the number field using the inspector data formatting.
Number with Data Formatting with thousand separator (NumberField) example: 1950.00 -> 1,950.00
if i combine it with text using calculation to add 3 (*) at the back ,
calculation = NumberField & " *** "
calculation = 1950.00 ***
what im trying to do is have the data formatting thousand separator retain,
solution = 1,950.00 ***
Thank you all!