Is it possible to add a comma to a number inside a concatenate formula?

I’d like to add a comma to a number value that I’m displaying in a detail w/ card view.

image

Any easy way to add a comma to the number after it says production deficit?

Please try wrapping the number column that denotes the energy quantity with TEXT()

CONCATENATE("Production Deficit: ", TEXT([Energy Value]) ,“KWh”)

[Energy Value] is assumed to be a number type column.

2 Likes

Easy, thanks!

2 Likes