Forum Discussion

ronniej7940's avatar
ronniej7940
New Member
3 years ago
Solved

How to add comma back to number after adding text

Hello, I have a measure that's calculating the sum of a value.  It's currently formatted to have comma's display.

 

I'm trying to make another measure that has text followed by the sum value, but the comma's get removed.  Is there a way to add them back?

 

Need Help
Tips and Tricks
  • hnguy71's avatar
    hnguy71
    3 years ago

    ronniej7940 you can use the FORMAT function.

     

    For numeric value:

    FORMAT([YOUR_MEASURE], "#,#")

     

    for percentage:

    FORMAT([YOUR_MEASURE], Percent)

2 Replies

  • ronniej7940's avatar
    ronniej7940
    New Member
    3 years ago

    I also want to add a percentage and I'm getting a similar issue 

     

     

    • hnguy71's avatar
      hnguy71
      Icon for Super User rankSuper User
      3 years ago

      ronniej7940 you can use the FORMAT function.

       

      For numeric value:

      FORMAT([YOUR_MEASURE], "#,#")

       

      for percentage:

      FORMAT([YOUR_MEASURE], Percent)