"Jsarna" wrote:

> Banging my head against the wall on this one.
>
> Running a matrix report in RS 2000. I have 2 groupings, Department and
> Company. I want to get a sum of total hours for each job code and
> Department and Company. The job code hours show up in the detail, as
>
> =Iif (Len(sum(Fields!HoursTotal.Value)) = 0 , 0,
> sum(Fields!HoursTotal.Value ))
>
> When I run the report, the sum for the department is off.
>
> Job A 8.0
> Job B 0.0
> Job C 8.2
> Job D 71.1
> Job E 99.5
> ---------
> Group Sum 186.7 (should be 186.8)
>
> Any idea of what is wrong?
>
> The Stored procedure returns values to 1 decimal place as a double.
>
> Joe
>