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 !
The division is not stored as a percentage, so in you case you need 4/5 decimals for the given example..
?How can I convert it to a percentage ?
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