Formula in reports

F

flymeoutofhere

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?
 
D

Duane Hookom

"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.
 
F

flymeoutofhere

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
 
D

Duane Hookom

You didn't reply with sample records and desired results. You only provided
some descriptions with numbers that total 90 rather than 100.
 
F

flymeoutofhere

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
 
D

Duane Hookom

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, ...
 
F

flymeoutofhere

ok sorry, its too hard to explain. ill try to think it over again

thankyou for all of your time and effort anyway
 
Top