you will need to generate the flag in the script as negative for the credit transaction and then you will have to use that flag in your reports as well. I hope you are already doing it in your reports. so you just need to modify your script to make the flag negative when the transaction type is CR. try using below code.
IF(Tran_CTranType='RR','1'))))) AS Revenue_Flag;
may be this will help you.
Thanks & Best Regards,
Thank you for your quick reply! I had tried that before and it still wasn't showing the transaction items as -1 in the report. I have edited the script again to the -1, and here is the expression I'm using to sum the units:
When I look at the items listed in the report filtered down to Credits only, I see the units at "1" instead of "-1", but the dollar amounts are in parentheses to indicate a negative amount.
Is there something else I should be doing in my expression? I am trying my best to figure this out on my own, but I am really stuck on this one (and it's probably an easy fix!)
Thanks for the help!