Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula Calculation

Status
Not open for further replies.

vsharma79

Programmer
Aug 22, 2002
15
AU
Hi!

How can I get a calculated field at the end of the report that is derived by adding and subtracting the sum of columns in the report.
Do I have to insert a text object first an then right click on it to select formula or is there something else? to give you an example, there are four columns in the report

A B C D

I need a vlaue at the end of the report that calcullates Sum(A) + Sum(B) + Sum(C) - Sum(D).How do I go about doing this.

Vik
 
You do it exactly like that.

Create a formula, and enter Sum(A) + Sum(B)...etc.

Then drop the formula at the end of your report.

Naith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top