Percentage & Division question

[Guest]

My question is this:

I am trying to use a text box to calculate the overall percentage complete
of ALL the projects.

I have a query that outputs the percentage complete of 10 different projects.

Since the number of projects is constantly changing, i cant simply inter an
integer in the formula, i need to count the number of projects at any time.

At the moment i have a text box that counts the "number of projects", and a
second text box that sums all the "total percentages". I have tried to use a
third text box to divide the "total percentage" by the "number of projects"
but i cant create the correct divide formula. I keep getting an "#Error"
output in my report.

Can you help with the third text box, or show me how to do all of this in
one text box?

Thank you

 

[Joseph Meehan]

My question is this:

I am trying to use a text box to calculate the overall percentage
complete of ALL the projects.

I have a query that outputs the percentage complete of 10 different
projects.

Since the number of projects is constantly changing, i cant simply
inter an integer in the formula, i need to count the number of
projects at any time.

At the moment i have a text box that counts the "number of projects",
and a second text box that sums all the "total percentages". I have
tried to use a third text box to divide the "total percentage" by the
"number of projects" but i cant create the correct divide formula. I
keep getting an "#Error" output in my report.

Access seems to be smarter than I thought.

Think about what you really want. Do you want the average of the
percentages or do you want the average of all the projects completed? They
are not the same thing.

Consider:
Total parts Parts complete Average
Project A 2 1 50%
Project B 500 5 1%
Total 502 6 ???

Your formula would give 25.6%
The total completed is 1.95%

Without really thinking about the question you asked, I am going to
guess that it is trying to calculate the result before the source numbers
are available and you are ending up with a null somewhere in the formula.

 

[Guest]

You are right. I hadent thought the whole thing through properly.

What ive got now is this:

One text box that has the summed "total of parts required".

A second text box has the summed "total of parts delivered".

All i want to do is divide "total of parts delivered" by "total of parts
required". If i set the text format to percentage, then the output of this
formula should be a percentage.

My formula at present is as follows, but it returns a "#Error" in the
report. I think it is because i dont know how to reference a text box
correctly for use in a formula.

=[total of parts delivered]/[total of parts required]

What do you suggest?

Thanks for your help

Crimbo

 

[Joseph Meehan]

You are right. I hadent thought the whole thing through properly.

What ive got now is this:

One text box that has the summed "total of parts required".

A second text box has the summed "total of parts delivered".

All i want to do is divide "total of parts delivered" by "total of
parts required". If i set the text format to percentage, then the
output of this formula should be a percentage.

My formula at present is as follows, but it returns a "#Error" in the
report. I think it is because i dont know how to reference a text box
correctly for use in a formula.

=[total of parts delivered]/[total of parts required]

What do you suggest?

Thanks for your help

Crimbo

...

I am going to take a couple of wild guesses.

Is it possible you are getting a zero total parts required?

Is it possible that either field is text and not number?