Microsoft KB Archive/124647: Difference between revisions
(importing KB archive) |
(wikify table) |
||
Line 52: | Line 52: | ||
A running total or average displays the sum or average of all the values in a specific field up to any given record. In Microsoft Works, you can keep a running total and a running average by using self-referencing formulas. The table below resembles a database that contains running totals and averages, in which blank values are not counted in the average.<br /> | A running total or average displays the sum or average of all the values in a specific field up to any given record. In Microsoft Works, you can keep a running total and a running average by using self-referencing formulas. The table below resembles a database that contains running totals and averages, in which blank values are not counted in the average.<br /> | ||
<br /> | <br /> | ||
{| class="wikitable" | |||
!Values | |||
!Number | |||
!Total | |||
!Average | |||
|- | |||
|20 | |||
|1 | |||
|20 | |||
|20 | |||
|- | |||
|40 | |||
|2 | |||
|60 | |||
|30 | |||
|- | |||
| | |||
|2 | |||
|60 | |||
|30 | |||
|- | |||
|60 | |||
|3 | |||
|120 | |||
|40 | |||
|- | |||
|80 | |||
|4 | |||
|200 | |||
|50 | |||
|- | |||
|100 | |||
|5 | |||
|300 | |||
|60 | |||
|} | |||
<br /> | <br /> | ||
<br /> | <br /> |
Latest revision as of 11:58, 18 April 2021
Article ID: 124647
Article Last Modified on 11/15/2004
APPLIES TO
- Microsoft Works 4.0 Standard Edition
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.5a
- Microsoft Works 2.0a
- Microsoft Works 3.0 Standard Edition
- Microsoft Works 3.0a
- Microsoft Works 3.0b
This article was previously published under Q124647
SUMMARY
A running total or average displays the sum or average of all the values in a specific field up to any given record. In Microsoft Works, you can keep a running total and a running average by using self-referencing formulas. The table below resembles a database that contains running totals and averages, in which blank values are not counted in the average.
Values | Number | Total | Average |
---|---|---|---|
20 | 1 | 20 | 20 |
40 | 2 | 60 | 30 |
2 | 60 | 30 | |
60 | 3 | 120 | 40 |
80 | 4 | 200 | 50 |
100 | 5 | 300 | 60 |
To create a sample database similar to the one in this article, use the steps in the following procedure.
MORE INFORMATION
To create a table resembling the above example, do the following:
- In a new database, create 4 fields: Values, Number, Total, and Average.
- Switch to List view.
- In Record 1, type the following data (press ENTER after each entry):
- In the Values field, type 20.
- In the Number field, type 1.
- In the Total field, type the number located in Values.
- In the Average field, enter the following formula:
=Total/Number
- In Record 2, enter the following data:
- In the Values field type, 40.
- In the Number field, enter the following formula:
=Number+IF(Values,1,0)
- In the Total field, enter the following formula:
=Total+Values
- Continue entering numbers above in the Values field.
At this point, every value entered in the Values field will automatically place the correct values in the following 3 fields.
A running total will be calculated in the Total field while a running average will be calculated in the Average field.
Additional query words: 2.00a 3.00 3.00a 3.00b 4.00 4.50 4.50a w_works recursion accumulative cumulative recursive
Keywords: kbhowto kbfaq KB124647