Skip to Content
avatar image
Former Member

Crystal Reports 2011 - Small Negative Value Display Issue


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers