Exporting report shows values as negative values

building reports crystal reports
1

Hi

I am trying to show negative values as a positive when exporting a report from crystal into excel

I have tried abs function and crNoNegativeSign
“if Sum ({@Monthbalance}) <= 0 then crNoNegativeSign”

However the cells with the values are displaying correctly as positive values however the function bar at the top in the excel report still shows as a negative

Is there a way in crystal report to ensure values shows as positive in the cell and function bar

Thank you :slight_smile:
crystal snapshot.PNG

Ckaur (BOB member since 2016-11-17)

2

The only way I know is to ‘process’ the fields in a formula and change them to a positive number so that the number are positive when exported. It appears that you are just doing display formatting.

kevlray :us: (BOB member since 2010-06-23)