Forum Discussion
ronniej7940
3 years agoNew Member
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...
- 3 years ago
ronniej7940 you can use the FORMAT function.
For numeric value:
FORMAT([YOUR_MEASURE], "#,#")for percentage:
FORMAT([YOUR_MEASURE], Percent)
ronniej7940
3 years agoNew Member
I also want to add a percentage and I'm getting a similar issue
- hnguy713 years ago
Super User
ronniej7940 you can use the FORMAT function.
For numeric value:
FORMAT([YOUR_MEASURE], "#,#")for percentage:
FORMAT([YOUR_MEASURE], Percent)