Our business has some unique requirements that prevent us from using commission calculations using the built in commission engine. We have to run reports and calculate in Excel right now. However, I think I can get a saved report configured so that we don't have to export, but I need some help.
Right now I have three columns that I need to combine: a formula that gives me a Net Invoice total without tax, estimated extended cost on the transaction, and a journal entry amount that needs to be subtracted from the cost. Here is what they look like:
What I need is a new column that does this:
Net Invoice - (Est Extended Cost - JE #: Amount)
That would give me my gross profit on the invoice. Then I'd also need to take the gross profit amount, divide it by the net invoice amount, and multiply by 100 to get the gross profit percentage.
Problem is, I have no idea how to do that. Any advice?