+23I have some numbers i need to include in a string.
These numbers needs to be rounded down to two decimals, which I use ROUND() to do, my problem comes if the number has trailing zero's fx:
Does anyone know how can keep the trailing zeros?
Best answer by Sho
It looks easy, but it was a bit of a challenge.
ROUNDDOWN({Number}, 0) &
"." &
IF(
FIND(".",ROUND({Number}, 2)&""),
REGEX_EXTRACT(
ROUND({Number}, 2)&"0",
"\\.(\\d{1,2})"
),
"00"
)
There has been a number field update recently, and it would be nice if formatted numbers could be used in Formulas as well.
+10Hi @Kim_Trager1
You should be able to resolve this issue by specifying the precision on your formula field in the formatting tab when you edit a field. If your formula field is a number you should get a result like this where you can specify the decimal places you would like to be visible.
+23Hi @Kim_Trager1
You should be able to resolve this issue by specifying the precision on your formula field in the formatting tab when you edit a field. If your formula field is a number you should get a result like this where you can specify the decimal places you would like to be visible.
Thank you for this, however the number is part of a longer text. Like: "blablablabla £250.00 blablabla"
So it's how do I get the 250.00 to be "blablablabla £250.00 blablabla" instead of "blablablabla £250 blablabla"?
It looks easy, but it was a bit of a challenge.
ROUNDDOWN({Number}, 0) &
"." &
IF(
FIND(".",ROUND({Number}, 2)&""),
REGEX_EXTRACT(
ROUND({Number}, 2)&"0",
"\\.(\\d{1,2})"
),
"00"
)
There has been a number field update recently, and it would be nice if formatted numbers could be used in Formulas as well.
+23This is beautiful, thank you so much. It was not as easy as I thought it would have been.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.