Nested Query with an iif statment part 2
The formula you provide worked. Thank you.
But the problem I’m having now is with the formula below, which is very similar to the formula you provide.
Basically what I’m trying to do is if the name Diana Grover shows up for a buyer I need to divide 1: the qty 2: Retail 3: Cost
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 (2)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
