8 Replies Latest reply on Aug 16, 2018 8:49 PM by Derek Taylor

    Displaying commas in numbers which are shown as string

    Kanika Raheja

      My data has a field named “Product Target” which is zero wherever the target for a product is not available. To display the zeroes as “Not available”, I created a calculated field as shown below:

       

      IF sum([Product Target1])>0 THEN STR(INT(sum([Product Target1])))

      ELSE "Not Available"

      END

       

      But as the above calculated field returns a string, the numbers appear like 12345 without any comma separators. Is there any way to insert comma separators in these text fields?