please help with iif 1

[pduncan]

I have a report that calculates an invoice total by using an unbound field that is set to this:

=([QtyShip]*[RegionalAmountDue])+[OtherTax]+[Freight]+[RegionalTax]

the problem is that when a credit is issued, the qty shipped id -1, which causes the invoice total to be incorrect. I assume I could use the IIF function on the QtyShipped field, but I keep messing something up. Can someone please show me how to conditionally make QtyShipped a positive number if it is negative?


Thanks, PDUNCAN

 

[Databaseguy]

Use the absolute function ?

=(abs([QtyShip])*[RegionalAmountDue])+[OtherTax]+[Freight]+[RegionalTax]

 

[pduncan]

That did it - thanks and a STAR!

Thanks, PDUNCAN