Displaying Numbers in Crystal 9.0 Crosstab Report

[cfriedberg2]

I am creating a crosstab report that contains Sales and Cost of Sales. By letting the COS field display as a negative, the Total is correct. I have been asked to not show the COS as a negative. How do I do that and still have the columns operate correctly?

 

[Kendel]

Do you want to show COS as positive number or just hiding it?

 

[cfriedberg2]

I want to display it, but I want to subtract it from Sales.

 

[Kendel]

Just use Abs() or just use "format field" to display it. But in summary, use the real value.