Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to convert a number to a string ? (Problem with decimals)

Topic Labels: Formulas
3623 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Beerfood_hello
4 - Data Explorer
4 - Data Explorer

Hello everyone,

Unfortunately, I’ve a problem when I CONCATENATE(Montant HTVA)
Capture d’écran 2021-03-04 à 11.49.09

As you can see, I have decimals that appears from nowhere :frowning: I need to convert my prices into string to be able to generate an invoice that include all my items lines.

How can I solve that problem?

4 Replies 4
Mariusz_S
7 - App Architect
7 - App Architect

Hey @Beerfood_hello

Instead of
CONCATENATE(Montant HTVA) use ROUND(Montant HTVA,2)

Beerfood_hello
4 - Data Explorer
4 - Data Explorer

Thanks for your answer, but it doesn’t works :confused: When I use it for “Montant HTVA”, it shows only the integral number

Make sure to update the formatting to show decimal places.
Then you’d need to another formula field to “join” the values if you need the EURO sign at the end.

I replicated your example and fully expected to get a sensible result, unlike yours. But no, I got those weird trailing decimal places as well.

ROUND doesn’t work as you would expect either. I think there’s something going on under the hood with floating point variables.

What you are trying to do should be possible and work as you would expect.