+14Converting number to text dropping training zeros
Description: I have a number 28.0692641000000 that I am trying to convert to text in a formula field.
My formula is:
Text(28.0692641000000)
It returns 28.0692641
I want it to return 28.0692641000000
Can this be done in Skuid or SF?
Best answer by bill.fox2
Had to do this in apex
+17Trailing decimal places that are zeros are really not anything and are not stored in math operations.
You will have to put together a pretty complicated operation that does the following.
Find the number of decimal places where there are values (in the example above it is 7)
I"m not sure this can even be done in a Formula - feels like a custom code solution to me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
