Formulas

  • Thread starter Daniel Biancuzzo
  • Start date
D

Daniel Biancuzzo

In the detail section of a report I have designed, I have a text box with
the formula "=[QNTY]*[PRICE]" in a column with the heading "SUBTOTAL"
defined in the page header of the report. The text box with the formula is
"Text36". So in the report footer I am trying to insert a formula in
another text box to do the overall total by using
"=Sum(Reports![Reportname]![Text36]).

The formula in the text box within the report detail section works fine,
however the overall total in the report footer shows up blank. Does anyone
know what I am doing wrong?
 
M

Marshall Barton

Daniel said:
In the detail section of a report I have designed, I have a text box with
the formula "=[QNTY]*[PRICE]" in a column with the heading "SUBTOTAL"
defined in the page header of the report. The text box with the formula is
"Text36". So in the report footer I am trying to insert a formula in
another text box to do the overall total by using
"=Sum(Reports![Reportname]![Text36]).

The formula in the text box within the report detail section works fine,
however the overall total in the report footer shows up blank. Does anyone
know what I am doing wrong?
Click to expand...


The aggregate function are unaware of controls on the
report, they only work with fields in the report's record
source table/query. Use this instead
=Sum([QNTY] * [PRICE])
 
Top