3 Replies Latest reply on Jun 8, 2015 9:48 PM by philmodjunk

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

    starstuff

      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!