I have a Price calculated of € 9.60 (setting 2 decimals). When I use the amount in Concatenate it shows:The price is € 9.6 less.
How do I get the zero back in? A calculation result of € 9.61 goes well.
Could you please try
CONCATENATE("The price is “, TEXT([Price Column]), " less”)
2 Likes
Seems to work. Thanks!
1 Like
The reason is the TEXT() expression which follow your locale settings.
3 Likes
For reference:
1 Like