Skip to Content
0

Crystal Reports 2011 - Small Negative Value Display Issue

Feb 03, 2017 at 04:56 PM

65

avatar image

Hello,

I am using Crystal Reports 2011.

I have a numeric field value that is -0.0005 and I am rounding to 2 decimal places.

As a result the field is rounding to 0.00.

I would like to display this value as '-0.00%' in the report.

I have 'Show Zero Values as' set to '<Default Format>' and I am using '%' as my currency symbol. So the value is currently displaying as '0.00%'.

I don't appear to have the ability to add the negative sign as well.

I need to leave this field as a number, so a custom formula field is out of the question.

Any suggestions??

Thanks in advance.

number-props.jpg (60.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers