How to display zero negative values in brackets?

[EArumugam]

hi all,

Display the negative values inside the bracket after round the values to 2.

for ex:

-0.045 --> _round(-0.045,2) --> (0.05) displaying correctly
-0.0025 --> _round(-0.0025,2) displaying as 0.00 instead of (0.00)

I want to display it as (0.00). please tell me how to achieve this ?

thanks,
eas

[mrcool]

Have you played with number formate in properties?like setting 0 value characters as (0.00) .

[RobsWalker68]

hi all,
-0.045 --> _round(-0.045,2) --> (0.05) displaying correctly
-0.0025 --> _round(-0.0025,2) displaying as 0.00 instead of (0.00)

I want to display it as (0.00). please tell me how to achieve this ?

eas

Shouldn't  _round(-0.0025,2) be rounded to 3dp instead of 2dp.  2dp wil equate to 0.00 whereas 3 dp will equate to -0.003

Rgds

Rob

[EArumugam]

thanks rob,

i applied data format as percentage to that column in crosstab report deimal places as 2 , negative symbol as ().
-0.045 -->  (0.05) displaying correctly
-0.0025 --> displaying as 0.00 instead of (0.00)


-eas