I
IreneJ
Can anyone please help me with this problem. I have a
running sum field in a report for job categories, they
total on each Call ID and then have a Grand Total where
the total of all of them come together at the bottom to
be included with the other rates based on the total
amount for the Date. My challenge is that they all total
fine for each date on Group All except when one of the
items in the job category field has a 0.00 value, then
the running sum stops at the item above it say 145.00,
doesn't do anything with the zero value one and then puts
a 0.00 value in the Grand Total field instead of the
145.00. As long as the fields are all full it seems to
work.
Can anyone help me with what would be correct to make
this work so that the amount that is supposed to be on
the bottom shows up.
Thanks, all help gratefully appreciated.
IEJ
running sum field in a report for job categories, they
total on each Call ID and then have a Grand Total where
the total of all of them come together at the bottom to
be included with the other rates based on the total
amount for the Date. My challenge is that they all total
fine for each date on Group All except when one of the
items in the job category field has a 0.00 value, then
the running sum stops at the item above it say 145.00,
doesn't do anything with the zero value one and then puts
a 0.00 value in the Grand Total field instead of the
145.00. As long as the fields are all full it seems to
work.
Can anyone help me with what would be correct to make
this work so that the amount that is supposed to be on
the bottom shows up.
Thanks, all help gratefully appreciated.
IEJ