The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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.