Total of calculated field

  • Thread starter Thread starter baraka
  • Start date Start date
B

baraka

This could be very easy, but it is given me some pain. I wish to total in a
report's footer the sum of the product of two fields that is given in a
third unbound field.

How do I go about doing this?

BDSD
 
baraka said:
This could be very easy, but it is given me some pain. I wish to total in a
report's footer the sum of the product of two fields that is given in a
third unbound field.

How do I go about doing this?
Click to expand...

=Sum([SomeField]*[SomeOtherField])
 
Thanks Rick. It worked

Rick Brandt said:
baraka said:
This could be very easy, but it is given me some pain. I wish to total in a
report's footer the sum of the product of two fields that is given in a
third unbound field.

How do I go about doing this?
Click to expand...

=Sum([SomeField]*[SomeOtherField])
Click to expand...
 
Sorry Rick, I have come back again. That worked fine for the section footer.
Now I would like to sum the totals of all such section footers to a grand
total, so I tried the same formula again but then on opening the report it
requested input of the text box parameters that is contained in the section
footers.

How do I go about this?

Thanks

BDSD
baraka said:
Thanks Rick. It worked

Rick Brandt said:
baraka said:
This could be very easy, but it is given me some pain. I wish to total in a
report's footer the sum of the product of two fields that is given in a
third unbound field.

How do I go about doing this?
Click to expand...

=Sum([SomeField]*[SomeOtherField])
Click to expand...
Click to expand...
 
baraka said:
Sorry Rick, I have come back again. That worked fine for the section footer.
Now I would like to sum the totals of all such section footers to a grand
total, so I tried the same formula again but then on opening the report it
requested input of the text box parameters that is contained in the section
footers.

How do I go about this?
Click to expand...

You should have used the exact same expression. Is that what you did? The "grand
total" aspect is achieved by where the control is placed. You should not have had to
change it at all. Also you would need to place this in the ReportFooter, not the
PageFooter. Aggregation functions do not work at the page level.
 
Thanks Rick.
Rick Brandt said:
You should have used the exact same expression. Is that what you did? The "grand
total" aspect is achieved by where the control is placed. You should not have had to
change it at all. Also you would need to place this in the ReportFooter, not the
PageFooter. Aggregation functions do not work at the page level.
Click to expand...
 
Back
Top