Load certain values as negatives

[gerhardl]

Hi,

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.

Thanks,

G

[deepakk · Accepted solution]

hi,

If (code = 454 or code =400 , Amount*-1, Amount) as Amount.

I hope this helps.