How to remove decimal in BODS

[Former Member]

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

[former_member187605 · Accepted solution]

ltrim_blanks(to_char(decimal_field*100,'00000000'))

[Former Member]

That solved it.Thank you Dirk!