Print Page - Chart Y axis display billion

Title: Chart Y axis display billion
Post by: artemis_ai on 24 Sep 2019 03:39:11 AM

Hi, I am going to build a chart in cognos 10.2 in report studio , and in Y axis, I want the data display million/billion instead of detail data, like 1,000,000,000 show 1billion, I tried to change the Axis labels data format to Currency , and enter Billion in Currency Symbol, symbol position is End, and scale selected -9, but the result is only display Billion beside the data, like 1,000,000,000 billion . Can you help to figure out the reason and find the solution ?thanks.

Title: Re: Chart Y axis display billion
Post by: Andrei I on 24 Sep 2019 10:45:32 AM

Data Format - Pattern : #### Billion

Title: Re: Chart Y axis display billion
Post by: artemis_ai on 29 Sep 2019 09:50:28 PM

Hi stork,

Thanks, I tried, but the number in the chart Y axis still showing the full number in excel output, but ok in HTML..can we realize it in excel?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: artemis_ai on 24 Sep 2019 03:39:11 AM