In a report like the screenshot:
1) how can I have a Formula field that shows negative Units (-500 not 500) if sales is less than zero: If (Sales<0) Units * -1;
2) Can I do this without having Units field in the report?
I think I can only do this in a saved search, maybe, but I'm not sure how to know about reports without asking. The 'Add Formula Field' seems to offer only limited formulas.