I'm trying to create an SQL statement to pull in some values from an accounts package. The problem is that values are all stored as positive values but need to be negative for certain transaction types.
eg.
when [TRANTYPE] = "CRN", value = [GROSS] * -1
when [TRANTYPE] = "INV", value = [GROSS]
But my attempts at using IIF's have failed..
I'm feeling a little dumb on this one, can anyone help me?
Thanks in advance.
eg.
when [TRANTYPE] = "CRN", value = [GROSS] * -1
when [TRANTYPE] = "INV", value = [GROSS]
But my attempts at using IIF's have failed..
I'm feeling a little dumb on this one, can anyone help me?
Thanks in advance.