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

Help With Rounding!

Started by actcognosuser, 04 Apr 2011 02:37:05 PM

Previous topic - Next topic

actcognosuser

All,
       I have a rounding issue .i am using a crosstab.

Numerator: 37541
Denominator:37542

I want to display the % as 99.99 instead of 100.
I used the round function.How many digits should the integer expression be to get 99.99?_round(NM/DM , ?)

Even if i increase the number of digits i still get 100?

In the crosstab i have the data format set to percent with 2 digits after decimal.
thanks !



blom0344

The division is not stored as a percentage, so in you case you need 4/5 decimals for the given example..

actcognosuser

?How can I convert it to a percentage ?

blom0344

You do not..  Simply changing the dataformat layout in the dataitem properties will do the trick. There is no need to 'convert' anything.
Set dataformat to percentage and make sure you have the other settings (scale, decimals) right