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
Have you played with number formate in properties?like setting 0 value characters as (0.00) .
Quote from: Easwar on 29 Jun 2011 05:57:04 AM
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
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