If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Format Amount with Leading Zeros

Started by tsweep, 02 Jul 2013 04:25:15 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

tsweep

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).
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite