Totals on reports

  • Thread starter Thread starter Vijai Ponnezhan
  • Start date Start date
V

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.
 
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
 
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 -
Click to expand...

- Show quoted text -
Click to expand...

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?
 
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
 
Back
Top