Hello Gurus,
I have a requirement where the numbers should be displayed as below with fixed width of 8 and implied(removed) decimal. Can you please tell me how I can achieve this in SAP BODS Query?
150.00 ---> 00015000
2758.00 ---> 00275800
897.52 ---> 00089752
Thank you,
Priyansh
ltrim_blanks(to_char(decimal_field*100,'00000000'))
Add a comment