Print Page - Query calculation as percent format ?

Title: Query calculation as percent format ?
Post by: oscarca on 04 Dec 2018 01:58:17 AM

Is it possible to format calculation in Cognos Dashboard example sales/budget = 10% instead of 0.1

Best regards
Oscar

Title: Re: Query calculation as percent format ?
Post by: MFGF on 05 Dec 2018 03:37:28 AM

Quote from: oscarca on 04 Dec 2018 01:58:17 AM
Is it possible to format calculation in Cognos Dashboard example sales/budget = 10% instead of 0.1

Best regards
Oscar

Hi,

The easy way to do this is to add a calculation that takes the 0.1 value and calculates it as a percent of 1

(https://i.ibb.co/19WL7Ft/Dashboard-Percent.png)

Drag this calculation onto your dashboard and it will appear as a percent value. If you look at the format options you can choose the number of decimal places too.

Cheers!

MF.

Title: Re: Query calculation as percent format ?
Post by: oscarca on 06 Dec 2018 02:50:26 AM

Thank you MF, I'll try this.

Best regards,
Oscar

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: oscarca on 04 Dec 2018 01:58:17 AM