Summing Different Cycles

[Supe]

I have a report that shows the dates and hours worked by diffenrent Cycles in
the Detail Section so it appears like below

Cycle 1
Date 1/29/07 Hours 4.0
Cycle 2
Date Hours
Cycle 3
Date 2/2/07 Hours 6.0
Cycle 4
Date 2/11/07 Hours 8.0


Want to put a Sum in the footer that will add up the total hours. I am
working off a table where there is a separate field name for each Cycle:

Cycle 1 Hours 4.0
Cycle 2 Hours
Cycle 3 Hours 6.0
Cycle 4 Hours 8.0


Tried doing a sum by listing all the field names, but the total only appears
if there is a number in each of the fields???

 

[Damian S]

Hi Supe,

You need to handle nulls, that is the issue. Try using the nz function like
this:

=sum(nz([FIELDNAME], 0))

Damian.

 

[Supe]

How do I use if I have mulitple field names?

Hi Supe,

You need to handle nulls, that is the issue. Try using the nz function like
this:

=sum(nz([FIELDNAME], 0))

Damian.

I have a report that shows the dates and hours worked by diffenrent Cycles in
the Detail Section so it appears like below

Cycle 1
Date 1/29/07 Hours 4.0
Cycle 2
Date Hours
Cycle 3
Date 2/2/07 Hours 6.0
Cycle 4
Date 2/11/07 Hours 8.0


Want to put a Sum in the footer that will add up the total hours. I am
working off a table where there is a separate field name for each Cycle:

Cycle 1 Hours 4.0
Cycle 2 Hours
Cycle 3 Hours 6.0
Cycle 4 Hours 8.0


Tried doing a sum by listing all the field names, but the total only appears
if there is a number in each of the fields???