Difference between percentages

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

Guest

Let's see if I can explain this correctly....

Items Returned = 75
Items Sent = 125
Return Rate = 60%

What I want to end up with is the number of items i SHOULD be sending if i
want the return rate to be 20%. How do I write an expression that includes
the difference between the actual return rate and the desired return rate,
keeping in mind that there are multiple items and each item will have a
different return rat, so the numbers will change.

Help! And thank you.
 
Not sure what you are asking. We can tell you how to do this in Access, but
you have to tell us the formula you use.

Are you saying you want to know how many items you should be sending to
achieve a 20% return *if* there are 75 items returned? Is that really going
to be accurate? If you send more, won't you get more back?

I'm not sure what your "items" are, but typically, the return rate would
remain constant and the other 2 numbers would change. If this is a survey,
for example, sending out more should not change the percentage returned (6
out of 10 would still return them) but the actual number returned would
change.

In short, please clarify what you would like and we can help convert the
formula into Access-eze. Tell us how you do this now (on paper).
 
Dear Kat:

It sounds like you want some math. OK:

Items Sent * .2

That would be the desired return quantity of 25, right?

So the difference would be:

Items Returned - (Items Send * .2)

This is 50. You returned 50 items more than the 20%. 75 - 25 = 50.

Is this it?

Tom Ellison
 
kat said:
Let's see if I can explain this correctly....

Items Returned = 75
Items Sent = 125
Return Rate = 60%

What I want to end up with is the number of items i SHOULD be sending
if i want the return rate to be 20%. How do I write an expression
that includes the difference between the actual return rate and the
desired return rate, keeping in mind that there are multiple items
and each item will have a different return rat, so the numbers will
change.

Help! And thank you.
Click to expand...

75/.2 ?
 
Right now i'm doing it in an excel spreadsheet, but i would like to do it in
access.

the formula i'm using now (if the items sent is "D4" )
D4*(1-40%) (40 being the difference in percentage from 60, which is actual,
to 20, which is desired)
This gives me how many items i should be sending to achieve a 20% return
rate. I'm sure this is the hard way to do it, because i have to enter the
difference between the actual return rate for each item. I did set a
database up, but can't figure out the correct way to calculate.

Did this help or further confuse you? And if i'm totally calculating this
wrong, please let me know!
 
To clarify further....

The items sent remains constant, the items returned changes, changing the
return rate.
 
Back
Top