I’m trying to run a formula that will look for a name in on field and go to a different field and divide the 1: the qty 2: Retail 3: Cost

In a nutshell

If in field ([Buyer Name])=Person’s name, /qty
If in field ([Buyer Name])=Person’s name, /Retail
If in field ([Buyer Name])=Person’s name, /Cost

Below is the formula currently being used without the formula to divide the fields?

Field (1)Divide: Qty: Sum(IIf([OL_PRICE]*([OL_QTY_ORD]-[OL_QTY_CAN_TD])=0,0,([OL_QTY_ORD]-[OL_QTY_CAN_TD])))

Field (2)Divide: Retail: Sum(([OL_PRICE]*([OL_QTY_ORD]-[OL_QTY_CAN_TD])))

Field (3)Divide: Cost: Sum([OL_DMD_COST]*([OL_QTY_ORD]-[OL_QTY_CAN_TD]))

Thank you very much for your help, I’ve been working on these fixes for a number of months

I don't understand what you want. It looks like you are trying to divide a text field by a number field. This will cause errors.

Can you explain more?



mmcdonal

Corey, I thought we'd answered this on your previous posting (Nested IIf Statements). Perhaps you need to explain fully what you are trying to do. Are you using a form or are you trying to do this directly onto a table? If you need to chat 1 to 1 then use my MSN. It is difficult to help without understanding what you are trying to do fully.