COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tsweep on 02 Jul 2013 04:25:15 PM

Title: Format Amount with Leading Zeros
Post by: tsweep on 02 Jul 2013 04:25:15 PM
I would like to format an amount field with leading zeros and remove the decimal but keep the 2 digit cents.  I would also like to have trailing spaces for a text field.  Does anyone know how to accomplish this?  I've tried several things like right('0000000000' + [Amount],12).