I am fairly new at using Crystal Reports with Adagio and have been trying to create a formula that when the field has a "zero" qty it will return a - (dash)instead of a 0 otherwise it returns the value but have been unsuccessful. This is the formula I tried ...

IF {ICW65 Items.Qty on sales order} = 0 THEN "-" ELSE {ICW65 Items.Qty on sales order}

Can anyone tell me what I am doing wrong.

Thanks,