Trying to Sum (RegHrs+OTHrs+Parts)costs

[Hacim]

When I insert this "total cost" formula, I get a blank field or value.{WOP.TOTALPARTSCOST}+{@RegHrCost}+{@OTCosts}

//formula {@RegHrCost}= {WOE.REGHRS}*{WOE.RATE}

//formula {@OTCosts}= {WOE.OTHRS}*{WOE.OTFACTOR}*{WOE.RATE}

Is it possible that I get no result because one of the fields: reg. hours, ot hours or parts costs was left blank?
If so how do I tell Crystall to sum fields that are not blank and ignor or give a 0 to the fields that were left blank?
Thanks

 

[dgillz]

Under file, report options, make sure the "convert null field value to default" checkbox is selected. This will treat nulls like zeros is your formulas. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com