Expression

[rathnam_qv]

Hi all,

i hv Quantity field with all +ve values.

Transaction Type field there.

i want to write like if(Transaction Type='SALESORD',Quantity)...but i want to show quantity as -ve.

please help me how to do that.

[MK_QSL]

if(Transaction Type='SALESORD',-Quantity)

[alexandros17]

if([Transaction Type]='SALESORD',-1*Quantity)

[#4]

try this as well

Sum(if(Transaction Type='SALESORD',Quantity))* -1

thanks

Michael