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
