simple formula not working

[neronikita]

I have two columns - stop fee and linehaul. I have the formulas sorted by month then driver then truck. I want to add up the stop fee and linehaul for each level, so I used

LHplsSF= dispatch2012.stopfee + dispatch2012.linehaul

it only gives me an answer if there is data in BOTH fields. If one field is blank, it leaves the LHplsSF field blank. I can't think of any reason it is doing this. Ideas?

Thanks!!!!

Di

Crystal 2008

 

[neronikita]

Nevermind, my field was Null. I never thought of that because it doesn't show up in the report. I now have the following working formula:


if isnull({Dispatch2012.StopFee}) then {Dispatch2012.LineHaul} else
{Dispatch2012.StopFee} + {Dispatch2012.LineHaul}

I knew it had to be a simple answer.....