Unanswered: Separate subtotals for positive and negative values
I am a newbie. I'm trying to make MYOB (accounting package) do things it's not designed to do, and extract and process data in ways it doesn't want. I don't have a choice, I have to work with MYOB.
I have a report in Access of sales that are commissionable. It includes negative values from customers who have gotten refunds. Commission for those sales then need to be deducted from commissions.
I want a subtotal of all sales (the positive values) and a separate subtotal of all refunds (the negative values). Is there an expression that I can use in the footer that will do this? Or will I need to redo the groupings somehow in my query?