COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos74 on 20 Aug 2018 09:52:22 PM

Title: How to remove proceding zeros after decimal place
Post by: cognos74 on 20 Aug 2018 09:52:22 PM
Hi Friends,

please let me know how to remove the zeros after decimal place in cross tab report.
here is my example values in my crosstab node member:
1.000
2.125
8.600
60.000

I need to show above values like this in cross tab node member:
1
2.125
8.6
60

please provide your valuable thoughts.

Title: Re: How to remove proceding zeros after decimal place
Post by: Francis aka khayman on 29 Aug 2018 10:03:32 AM
looks like the figure is formatted to show three decimal digits. check the data property first