Calculating percentages

L

luscioussarita

I have a form in which I need help calculating percentages. I am trying to
get a percentage on the difference month over month. August and July were
originally currency.

=([August]\[July])

In properties I have changed the format to percent.

I get this for an answer: 106.88% and the answer should really be 6.88%

I also tried =(100%-[August]\[July]) but it didn't work. How do I take out
the 100% stuck in there. I know its something simple that I am over looking.

Any thoughts!
 
L

luscioussarita

I tried that and the number now has a negative sign. I tried to use ABS but
that forces all of it to positive. So the number now reads -6.88% instead of
6.88% and everything that is suppose to be negative is now positive.

I even put it like this

=(-1-[August]\[July])
and
=abs(1-[August]\[July])

but it didn't work too good!! any thoughts



Joshua A. Booker said:
Try this:

=(1-[August]\[July])

HTH,
Josh

luscioussarita said:
I have a form in which I need help calculating percentages. I am trying to
get a percentage on the difference month over month. August and July were
originally currency.

=([August]\[July])

In properties I have changed the format to percent.

I get this for an answer: 106.88% and the answer should really be 6.88%

I also tried =(100%-[August]\[July]) but it didn't work. How do I take
out
the 100% stuck in there. I know its something simple that I am over
looking.

Any thoughts!
Click to expand...
Click to expand...
 
G

George Nicholson

Subtract 1 from your result. (1 = 100%)

If August/July = 106.88% then:
1 - (August/July ) should give you -6.88%
(August/July ) - 1 should give you 6.88% (which is what you say you are
expecting)

Alternatively:
(August-July)/July should also give you 6.88% (the change from previous
month stated as a % of previous month).

HTH,
 
K

Klatuu

= [August]\[July] -1

luscioussarita said:
I tried that and the number now has a negative sign. I tried to use ABS but
that forces all of it to positive. So the number now reads -6.88% instead of
6.88% and everything that is suppose to be negative is now positive.

I even put it like this

=(-1-[August]\[July])
and
=abs(1-[August]\[July])

but it didn't work too good!! any thoughts



Joshua A. Booker said:
Try this:

=(1-[August]\[July])

HTH,
Josh

luscioussarita said:
I have a form in which I need help calculating percentages. I am trying to
get a percentage on the difference month over month. August and July were
originally currency.

=([August]\[July])

In properties I have changed the format to percent.

I get this for an answer: 106.88% and the answer should really be 6.88%

I also tried =(100%-[August]\[July]) but it didn't work. How do I take
out
the 100% stuck in there. I know its something simple that I am over
looking.

Any thoughts!
Click to expand...
Click to expand...
Click to expand...
 
L

luscioussarita

Thank you very much...I tried both ways and it worked perfectly...
I knew there was more than one way to skin a cat!

Sarita :)

George Nicholson said:
Subtract 1 from your result. (1 = 100%)

If August/July = 106.88% then:
1 - (August/July ) should give you -6.88%
(August/July ) - 1 should give you 6.88% (which is what you say you are
expecting)

Alternatively:
(August-July)/July should also give you 6.88% (the change from previous
month stated as a % of previous month).

HTH,
--
George Nicholson

Remove 'Junk' from return address.


luscioussarita said:
I have a form in which I need help calculating percentages. I am trying to
get a percentage on the difference month over month. August and July were
originally currency.

=([August]\[July])

In properties I have changed the format to percent.

I get this for an answer: 106.88% and the answer should really be 6.88%

I also tried =(100%-[August]\[July]) but it didn't work. How do I take
out
the 100% stuck in there. I know its something simple that I am over
looking.

Any thoughts!
Click to expand...
Click to expand...
 
Top