Help

Re: I need a formula for 2 decimal digits mixed with text

Solved
Jump to Solution
1124 0
cancel
Showing results for 
Search instead for 
Did you mean: 
LemonSorbet
4 - Data Explorer
4 - Data Explorer

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula :

"[90.0]"&" "&{product name}&" "&{weight)}
I tried using Round(), but it didn't help.  Screenshot 2024-04-25 103621.png
13 Replies 13

I've already tried this one, I had replied to another guy that some numbers are still incorrect. I added more digit in weight field to see if there are numbers behind it, but there isn't any. I tried to contact the support team too, but they havn't answer.

The weird part is that I put the same formula (yours and the other guy's), somehow now it shown different result as previously 2.20 was shown as ....2.03

You're just so INCREDIBLE. THANK YOU

The first weight part has to be INT though, or it will increase the number.

{productname}&" "&INT(weight)&"."&RIGHT(''&ROUND(weight*100),2)

You are welcome.
JFYI, extra digits are not visible until the number of digits hits Number type limit

Alexey_Gusev_0-1714139695708.png

In short, here is the explanation for Integer. I guess, something like this happens with floating point numbers, when you are trying to use text functions on them.