Calculating % based on negative divisor

  • Thread starter Thread starter Alisheba
  • Start date Start date
A

Alisheba

I created a report that calculates current balances to ending balance for
previous month and returns a percentage, my formula is as follows:

=([Variance]/[61+ Last Month])

It works except when [61+ Last Month] is negative it returns a negative %.
For example:
61+ Last Month = -441.60
Variance= $12,496.50

Formula returns -2829.82%

It should be a positive number meaning that my balance increased.

Please advise

Thank You
 
You seem to think that Access is doing something wrong, but really it's just
simple arithmetic.

4/2 = 2

4/-2 = -2

Presumably this will give you the answer you want:

=([Variance]/Abs([61+ Last Month]))
 
Back
Top