COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Ammus1234 on 18 Jan 2016 12:04:46 AM

Title: Positive numbers
Post by: Ammus1234 on 18 Jan 2016 12:04:46 AM
Hi Everyone,

Is it possible to change the positive number display in report studio.
I want the positive numbers to be displayed with a suffix +. For eg: +100 for 100.
My data source is MSAS cube.

Thanks in advance.
Title: Re: Positive numbers
Post by: sdf on 18 Jan 2016 03:28:53 AM
data format, put "+" on the pattern.
Title: Re: Positive numbers
Post by: BigChris on 18 Jan 2016 03:50:17 AM
@sdf - can you do that conditionally? I presume the values could be negative...
Title: Re: Positive numbers
Post by: MFGF on 18 Jan 2016 04:47:37 AM
Quote from: BigChris on 18 Jan 2016 03:50:17 AM
@sdf - can you do that conditionally? I presume the values could be negative...

No need, Chris. In the Data Format dialog there are both Pattern and Negative Pattern properties. You could set Pattern to +########## and Negative Pattern to -##########

Cheers!

MF.
Title: Re: Positive numbers
Post by: BigChris on 18 Jan 2016 05:11:55 AM
Cool - I've never really played with the Patterns, so that's good to know.
Title: Re: Positive numbers
Post by: Ammus1234 on 18 Jan 2016 11:44:38 PM
Thanks MFGF and sdf. It worked.