Calculated Column, Need help with formula please

cocoloco79 Can you try

FME =
IF(
    Prod[Crop] = "Sweet Corn",
    IF(
        AND(
            Prod[OuterProduct] = "PROC - WWFME - Bean Carrot Corn - Woolworths FME 8 x 350g - Cartons",
            Prod[Boxes] * Prod[qtyinner]
        ),
        Prod[Boxes x qtyinner],
        Prod[Crop.Units]
    ),
    Prod[Crop.Units]
)

OR

FME = IF(
    Prod[Crop] = "Sweet Corn",
    IF(
        AND(
            Prod[OuterProduct] = "PROC - WWFME - Bean Carrot Corn - Woolworths FME 8 x 350g - Cartons",
            Prod[Boxes] * Prod[qtyinner]
        ),
        Prod[Boxes x qtyinner],
        IFBLANK(Prod[Crop.Units], 0)
    )
)

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
If this post helps, please consider Accepting it as the solution to help others find it more quickly.