Formula in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to add a formula to a report to average a set of percentages. there
are five possible categories, each of which need an average. the averages for
each then need to be combined onto a weighted percentage with 45% weight on
one of the four. Should the formula be in the form footer and how should i
approach building it?
 
"the formula be in the form footer" suggests a form. I assume this is a
slip.

Could you try to provide more specific information on your request? Maybe
provide some sample records with desired results.
 
No sorry it is in the report.

i have four tasks say: task one, task two, task three, and task four and
i have four categories say a, b, c, d, e

for each task there is a mark for each category
say category a is out of 10, b, 20, c, 45, d, 5, and e, 10 to make 100, i
need to average the four marks to give an average mark for each category
which add to give a percentage (out of 100)

thankyou and sorry for the slip
 
You didn't reply with sample records and desired results. You only provided
some descriptions with numbers that total 90 rather than 100.
 
Sorry. Ill rexplain

There are four tasks call them
-Task 1,
-Task 2,
-Task 3 and
-Task 4
Each task is then split up into six categories
-Category A (out of 10)
-Category D (25)
-Category I (45)
-Category T (10)
-Category E (10)


Let me then give five samples

Say someone got the following marks
-Task 1
-Marks for categories
A)6 (out of total)
D)15
I)30
T)6
E)4

-Task 2
-Marks for categories
A)6 (out of total)
D)15
I)40
T)6
E)5

-Task 3
-Marks for categories
A)6 (out of total)
D)18
I)24
T)7
E)8

-Task 4
-Marks for categories
A)6 (out of total)
D)22
I)43
T)8
E)8

Sorry about the bad explanation and mistake
 
I'm sorry but you are describing data without the single use of critical
words like: table, record, or field. From your description, I would expect
you might have a table of tasks:

tblTasks (four records)
==============
TaskID
TaskName

tblCategories (6 records)
=============
CatID
Category
CatPossible (numbers like 10,25,45,..)

tblMarks (1 record per task per category per person)
=============
TaskID
CatID
Mark

Am I even close? I don't see how anyone can provide more than a guess
without understanding your table structure, table and field names, ...
 
ok sorry, its too hard to explain. ill try to think it over again

thankyou for all of your time and effort anyway
 
Back
Top