Could someone help me. This is based on fields on an item. Thanks!
I keep getting an error message--- ERROR: Invalid Expression
CASE WHEN {costestimatetype} = 'Purchase Price' THEN {cost}
ELSE
CASE WHEN TO_NUMBER({averagecost})= 0 THEN 0
ELSE {averagecost}/
CASE WHEN
TO_NUMBER({custitem_bbts_sales_conversion_rate}) = 0 THEN 0
ELSE
{custitem_nswms_casepack} / TO_NUMBER({custitem_bbts_sales_conversion_rate})
END
END
END