Hi,
We want Zero-padded, two decimal value, without the decimal point. For example if it is 14.31, we need 001431.
I have done "multiply" with 100 and "formatNumber" as '000000'
SFIeld --> multiply * 100 --> formatNumber (000000) --> TField
It works good for values with decimal like above 14.31, does it work for everything else too? I mean for 12 it is populating as 001200. Is this best approach? Is there any other std funtions or UDF sample available?
Regards,
N@v!n