Problem with Sum Hours

[qlan]

Hello,

I have 3 field names:
tblLostTime.Sick tblLostTime.Lost and tblLostTime.Late
20 10 5

For some reasons, I could not sum all the fields together. What I'm trying to achieve is 35 hrs, which is 20+10+5. Below is the formula I have
Sum ({tblLostTime.Sick},{@Name})
+ Sum({tblLostTime.Lost},{@Name})+ Sum({tblLostTime.Late},{@Name}). Instead of 30 hrs as a sum, it gives me blank. Please help. Thanks

 

[kchaudhry]

Can you please share the contents of the @name

Secondly, why are you doing a sum? From the sample data it seems like you only have one value and you wont really need a sum here.

Kchaudhry

 

[lbass]

Sounds like you have a null value in one of the fields. You either need to go to file->report options->check "convert null to default values" or set up a formula for each field like the following and then use the formulas instead of the field within your summary formula:

if isnull({tblLostTime.Sick}) then
0 else
{tblLostTime.Sick}

-LB

 

[qlan]

Thanks LB, it works.