Over all total

  • Thread starter Thread starter jmm1954
  • Start date Start date
J

jmm1954

I have report that has totals by truck for id wa and mt which works correctly
and then i have a grand total for id wa and mt. I have been trying to add all
the id all the wa and all the mt together. i have tried the id wa and mt
overall summing and i get a real funky number 183.00 when the id total alone
is 25000. Help!!!
 
jmm1954 said:
I have report that has totals by truck for id wa and mt which works correctly
and then i have a grand total for id wa and mt. I have been trying to add all
the id all the wa and all the mt together. i have tried the id wa and mt
overall summing and i get a real funky number 183.00 when the id total alone
is 25000. Help!!!
Click to expand...


It's diffivult to figure out what ,ight be wrong without
knowing what you did to get the funky result.

Normally, if you use something like =Sum(ID) to get the
individual totals, then the overall total would simply be
like:
=Sum(ID) + Sum(WA) + Sum(MT)
 
i tested starting with id and i received the correct number for id and then i
added wa and was the correct number i added mt and no value returned i
switched out in a each field trying to figure it out they all add ok
seperately
 
That would happen if the MT field were Null in all of the
records. You can deal with that situation by using
Nz(Sum(MT), 0)
 
Back
Top