Syntax Error

[Kira]

I have had this expression work before, but I accidentally deleted it and when I put it back in it came up with this: Syntax Error (comma) in the expression

Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions]!Quantity,-([Inventory Transactions]!Quantity))

Know what's wrong with it?

 

[rainman89]

not exactly sure, but i think it might have a problem with this

Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions]!Quantity,-([Inventory Transactions]!Quantity))

 

[Kira]

what specifically? I tried deleting those three. And one at a time, but the error still comes up.

 

[neileg]

Try this

Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition",[Inventory Transactions].Quantity, -1*([Inventory Transactions].Quantity))

 

[Kira]

Thanks worked perfectly.