AnsweredAssumed Answered

How to Combine Text and Number but Retain Thousand Separator ( , )

Question asked by starstuff on Jun 8, 2015
Latest reply on Jun 8, 2015 by philmodjunk

Title

How to Combine Text and Number but Retain Thousand Separator ( , )

Post

Hi All,

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!

Outcomes