Total of calculated field

[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

 

[Rick Brandt]

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?

=Sum([SomeField]*[SomeOtherField])

 

[baraka]

Thanks Rick. It worked

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?

=Sum([SomeField]*[SomeOtherField])

 

[baraka]

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

Thanks Rick. It worked

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?

=Sum([SomeField]*[SomeOtherField])

 

[Rick Brandt]

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?

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.

 

[baraka]

Thanks Rick.

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.