Formula: >WITH BREAKDOWN PER LANDED COST CATEGORY
*Amount per Landed Cost Category = CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END
--Note: Replace XXXX with the name of the Landed Cost Category on your account. Add as many columns/formula as necessary.
*Total Landed Costs = MAX(CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END)+MAX(CASE WHEN ({memo} LIKE '%YYYY%') THEN {amount} else 0 END)
--Note: Add all the formula of all the Landed Cost Categories
*Total Value per Item = MAX({amount})+MAX(CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END)+MAX(CASE WHEN ({memo} LIKE '%YYYY%') THEN {amount} else 0 END)
--Note: MAX({amount})+formula for Total Landed Costs
*Average Cost per Item = (MAX({amount})+MAX(CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END)+MAX(CASE WHEN ({memo} LIKE '%YYYY%') THEN {amount} else 0 END))/MAX({quantity})
--Note: (MAX({amount})+formula for Total Landed Costs)/MAX({quantity}) >TOTAL ONLY
*Total Landed Costs = ABS(CASE WHEN {account} LIKE '%Landed%' THEN {amount} ELSE 0 END)
*Total Value per Item = ({amount})+ABS(CASE WHEN {account} LIKE '%Landed%' THEN {amount} ELSE 0 END)
*Average Cost per Item = (SUM({amount}+ABS(CASE WHEN {account} LIKE '%Landed%' THEN {amount} ELSE 0 END)))/MAX({quantity})