Totals on reports

[Vijai Ponnezhan]

I am trying to get a total of 3 different fields (1st payment, 2nd payment,
3rd payment) for all the records and display it in the report footer.
The expression I built in the footer was =Sum([1st payment]+[2nd
payment]+[3rd payment]). This however returns with a blank. Please help.

 

[Rob Parker]

If any record contains a null in any of the three fields, your expression
will return null (ie. blank).

You can wrap each field in an Nz function to convert nulls to zero before
adding the fields:
==Sum(nz([1st payment],0)+nz([2nd payment],0)+nz([3rd payment],0))

HTH,

Rob

 

[Erlang]

If any record contains a null in any of the three fields, your expression
will return null (ie. blank).

You can wrap each field in an Nz function to convert nulls to zero before
adding the fields:
    ==Sum(nz([1st payment],0)+nz([2nd payment],0)+nz([3rd payment],0))

HTH,

Rob

I am trying to get a total of 3 different fields (1st payment, 2nd payment,
3rd payment) for all the records and display it in the report footer.
The expression I built in the footer was =Sum([1st payment]+[2nd
payment]+[3rd payment]).  This however returns with a blank.  Pleasehelp.- Hide quoted text -

- Show quoted text -

I have four different columns. These are Question, Problem,
Suggestions, Referral. I am trying to figure out if I have another
column called Grand Total. I want that Grand Total to sum Question,
Problem, Suggestions, Referral values rather than to sum each
Question, Probelm, Suggestions, Referral and give me the answer. Do
you have any suggestions?

 

[Rob Parker]

The following expression, in a textbox control in the report footer section,
will give the grand total of your four fields:
=Sum([Question]) + Sum([Problem]) + Sum([Suggestions]) + Sum([Referral])

Unlike the previous question in this thread, you will not need to wrap each
field in the NZ function - the Sum function takes care of this
automatically. All you must do is put the Grand Total textbox in the report
footer, not in the detail section.

HTH,

Rob