Apr 24, 2024 08:42 PM
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 :
Solved! Go to Solution.
Apr 25, 2024 11:48 PM
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
Apr 25, 2024 11:59 PM
You're just so INCREDIBLE. THANK YOU
Apr 26, 2024 12:03 AM
The first weight part has to be INT though, or it will increase the number.
{productname}&" "&INT(weight)&"."&RIGHT(''&ROUND(weight*100),2)
Apr 26, 2024 07:02 AM
You are welcome.
JFYI, extra digits are not visible until the number of digits hits Number type limit
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.