malcolm.garbett (11/5/2012)
Jeff Moden (11/5/2012)
Nah... you didn't mislead. I forgot to include the column name being checked by the case statement. You picked up on that correct, it would appear.For your output, just alias the CASE statement with columnname = CASE .... and you should be all set.
Forgive me for being obtuse but...
Does this mean there will always be two columns though? Or is there a way to have just one column with the minus prefix when the conditions of the CASE statement are met?
(Really appreciate this help, by the way. 🙂 )
You can remove the Amount column that doesn't have the CASE statement. The Case statement will do just as you asked. It'll return a negative amount when the INV/Credit column starts with "SC" and a positive amount for everything else.
--Jeff Moden
Change is inevitable... Change for the better is not.