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.