Forum Discussion
Helper VConcatenate Measure & Retain Formatting
Hello Good Day,
When i conctatenate a string to a measure "value", the measure "AvgValue" loses its formatting
For example, if the measure [value] result is 100,000
and if i use the below measure:
AvgValue = "The average value is " & [value]
the result is --> The average value is 100000
I am now missing the "," in the number.
Anyway to RETAIN the formatting in the concatenated measure?
Cheers
@hackfifi
Adjust the value with the FORMAT function.AvgValue = "The average value is " & FORMAT([Value], "0,0")
If you need decimal places, do it "0,0.00"________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
1 Reply
- Fowmy
Super User
@hackfifi
Adjust the value with the FORMAT function.AvgValue = "The average value is " & FORMAT([Value], "0,0")
If you need decimal places, do it "0,0.00"________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂