Help with a formula
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
|