message has been deleted

Formula (numeric) and formula = '0'

presuming you're talking about "Discount Amount", and that is the native "Amount Discount" field, you would use this formula (either numeric or currency):

NVL({discountamount},0)

this would have the actual discount amount, or zero if there was none

awesome that worked...do you know by chance how to make the date in mm/dd/yyyy for format instead of the below

it's based on your account or user preferences, but to force it into a specific format, use a formula(text) field with the TO_CHAR Function

thanks it worked