How would I go about loading the values of certain fields as negative, IF another field meets certain criteria?
I have the following 2 fields - [Transaction Amount] and [Transaction Code].
Certain transactions are purchase reversals, so if I load them as negative numbers it is easier for me to show the Turnover (I can just sum the totals).
My statment must be:
Load [Tran Amount] as negative value IF [Tran Code] = 36 or 931.