Positive numbers

[Ammus1234]

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.

[sdf]

data format, put "+" on the pattern.

[BigChris]

@sdf - can you do that conditionally? I presume the values could be negative...

[MFGF]

@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.

[BigChris]

Cool - I've never really played with the Patterns, so that's good to know.

[Ammus1234]

Thanks MFGF and sdf. It worked.