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

Decimal Format

Started by cogDev, 15 Jun 2011 07:35:26 PM

Previous topic - Next topic

cogDev

Hi,
I have a question about decimal places for my project
Users want to have a customized decimal format
If the number is less 10.00 then  number should be 9.00 format (2 decimal places)
If the number is between 10.00 and 99.00  then number should be 10.0 (1 decimal place)
If the number is over 100 then number should be 100 (0 decimal place)
With case statement and  round() I got all format correct but the only number ending with 0 or 00 after decimal gave just an integer. for example:  Original value 9.00 gives only 9  or 30.00 gives only 30 . So how do I place the decimal format where the original  number is 30.00 to 30.0 but NOT 30?
Thanks all in advanced.