Formatting the decimals

[Deepika15]

I have a column Units and some of the values in this column are with 4 decimals.

for eg the values are :2.4561, 125, -123.78

The requirement is to convert all the numbers in this column to show with 4 decimals.
eg:2.4561, 125.0000. (123.7800)

How can I achieve this

Thanks in advance.

Deepika

 

[almeids]

What product?
If Report Studio, set number of decimals in the Data Format property of the column.

 

[Deepika15]

Hi,
Thanks for your mail.It is in Report studio.In the Data format in numbers.Can you please let me know exactly in Numbers which field should i Use to achieve this.I tried using the patterns as 0.0000.i need to show the negative values also in parenthesis ( ).

Please let me know asap.

Deepika

 

[almeids]

Are you kidding?

 

[CognosProfessional]

Deepika15 - He just gave you the answer. The answer is in data format property. You are asking same question??

Set the decimals there, and set the negative sign there. That is it.

CP