Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 04, 2021 04:24 AM
Hello everyone,
Unfortunately, I’ve a problem when I CONCATENATE(Montant HTVA)
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?
Mar 04, 2021 05:31 AM
Hey @Beerfood_hello
Instead of
CONCATENATE(Montant HTVA)
use ROUND(Montant HTVA,2)
Mar 04, 2021 06:27 AM
Thanks for your answer, but it doesn’t works :confused: When I use it for “Montant HTVA”, it shows only the integral number
Mar 04, 2021 08:13 AM
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.
Mar 04, 2021 08:28 AM
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.