I am using Quick Reports for Dos version 6.5a. I am trying to prepare a
sales commission report and am having a problem calculating my gross profit.

I have a column for selling price, cost and gross profit. I am calculating
gross profit using the formula (selling price - cost). When both the
selling price and the cost are negative, in the case of a return, the
program is simply adding the two columns together.

example:

selling price = 12.00-
cost = 3.98-
-------
gross profit 15.98

can you offer any suggestions on how I can correct my problem?

The report is recognizing both the selling price and cost as being negative
numbers when I am totaling the columns and the formula is working fine when
both selling price and cost are positive numbers.

Hello Scott,

I cannot duplicate the issue that you are reporting.

From the results that you have provided, it looks as if you have a positive Selling price and you are trying to subtract a negative cost. Subtracting a negative cost is addition: 12 - -3.98 = 15.98

When the selling price is negative, a negative selling price minus a negative cost does result in a smaller negative: -12.00 --3.98 = -8.02

I did an equally simple formula based on Sales Analysis and tested a Credit Note. This is the formula: Sales amount - Cost of sales

These are the results:
Sales amount Cost of Sales Gross Profit
4.50- 3.00- 1.50-

Which program and version are you reporting on?