Hi All-
Can anyone help me with this gem:
LostSell-in: IIf(([Actual Lead Time by Item]![Avg Actual Supplier Lead Time Days]-[Actual Lead Time by Item]![Avg Planned Supplier Lead Time Days])<=0,0,Iif(([Actual Lead Time by Item]![Avg Actual Supplier Lead Time Days]-[Actual Lead Time by Item]![Avg Planned Supplier Lead Time Days])<=1,(([R12 Receipts by Item]![Receipts]*([Actual Lead Time by Item]![Avg Actual Supplier Lead Time Days]-[Actual Lead Time by Item]![Avg Planned Supplier Lead Time Days]))*(100-[Actual Lead Time by Item]![On Time Ship %]*0.01)*255))),Iif(([Actual Lead Time by Item]![Avg Actual Supplier Lead Time Days]-[Actual Lead Time by Item]![Avg Planned Supplier Lead Time Days])>=7,(([R12 Receipts by Item]![Receipts]/(7))*(100-[Actual Lead Time by Item]![On Time Ship %]*0.01)*255)),(([R12 Receipts by Item]![Receipts]/([Actual Lead Time by Item]![Avg Actual Supplier Lead Time Days]-[Actual Lead Time by Item]![Avg Planned Supplier Lead Time Days]))*(100-[Actual Lead Time by Item]![On Time Ship %]*0.01)*255)
I keep getting the error that I'm missing a bracket or pantesis, but I can't find it anywhere - I've counted and there are 18 open, 18 closed....
Thanks!