Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
If (code = 454 or code =400 , Amount*-1, Amount) as Amount.
I hope this helps.
hi,
If (code = 454 or code =400 , Amount*-1, Amount) as Amount.
I hope this helps.