Hello Community,
I am trying to get an desired output in the formula tool for a number dataset. I need all numbers to be 12 characters with leading and trailing zeros behind the decimal point. I have been able to get the leading zeros fine with padleft with the the trailing zeros after the decimal point and the "0" amount that is causing the issue for me.
Here are some examples.
Current Values
1541.71
663.3
0
Expected Output
000001541.71
000000663.30
000000000.00
Thank You in Advance
Solved! Go to Solution.
Hi @jstout
One way of doing this.
IF Length([F1])<2
THEN "000000000.00"
ELSE [F1]
ENDIF
Input used is below as you have already cracked the other's except 0.
Many thanks
Shanker V
Thank You @RobertOdera . This worked great for me.
@You are most welcome @jstout!