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 t...
  • 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)