Because of this (C for currency): format(…,’C’)
Use this instead (2 for 2 decimal point):
convert(numeric(11,2),(ItemCost-DiscountAmount+ExtraAmount)*QtyOrdered)
