Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if(Transaction Type='SALESORD',-Quantity)
if([Transaction Type]='SALESORD',-1*Quantity)
try this as well
Sum(if(Transaction Type='SALESORD',Quantity))* -1
thanks
Michael