total the subtotals

  • Thread starter Thread starter bizee
  • Start date Start date
B

bizee

I have a report that has sums for each cost item.

For a particular scope of work, I have the labor, material, contracts
totaled separately.
I want to add a total of those.

I added the box and it works somewhat. IF the items above ALL have a
total (some items may not have contracts, just labor). Then I get a
total of all those.
=Sum([Labor])+Sum([Material])+Sum([Sub-Contract])+Sum([Other-Direct])

If one of those items is blank, the new total line I tried to create
is blank. Seems all or nothing.

Probably something easy, but I'm lost

Thanks
 
The problem is that if something doesn't have a total, the Sum
function doesn't return 0, but null instead.

you could use the Nz Function i believe.

=Nz(Sum([Labor]), 0) + Nz(Sum([Material]), 0) + .....

i.e.

Nz(Value if Not Null, Value if Null)
 
Back
Top