COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: lots_of_questions on 19 Jan 2017 12:54:46 PM

Title: Conditionally change the data format scale
Post by: lots_of_questions on 19 Jan 2017 12:54:46 PM
Hi all,

I am creating an active report in Cognos 10.2.1

I have a control (slider or option button) that I am trying to change the scale of a number for the entire page.  IE. I am trying to conditionally change all numbers from Millions ($2.34M) to Thousands ($2347.5K) or Standard ($2,347,526). 

Is there anyway to do it without making a deck with multiple copies of every chart and crosstab?

Thanks.
Title: Re: Conditionally change the data format scale
Post by: MFGF on 20 Jan 2017 05:28:07 AM
Quote from: lots_of_questions on 19 Jan 2017 12:54:46 PM
Hi all,

I am creating an active report in Cognos 10.2.1

I have a control (slider or option button) that I am trying to change the scale of a number for the entire page.  IE. I am trying to conditionally change all numbers from Millions ($2.34M) to Thousands ($2347.5K) or Standard ($2,347,526). 

Is there anyway to do it without making a deck with multiple copies of every chart and crosstab?

Thanks.

No way I'm aware of other than using a deck with multiple copies, sorry.

MF.