Absolute Value Percentage Difference Question

Hi.

I've got a report where I'm making comparisons between 2 different
values. It's possible for the percentage difference from one value to
the next to be less than or greater than the original number.

If value 2 is 20% greater than OR 20% less than value 1, I want to
highlight that row in a table that I created.

Any thoughts on how to write the correct if statement that would yield
this result?

So far I have diff = (value1 - value2) / value1

.5 = (10-5)/10 which is a 50% decrease between the 2 values

Since the percentage difference is greate than 20%, how can I test that
50% in an if statement to highlight this difference for review?

THANKS!

Hi.

I've got a report where I'm making comparisons between 2 different
values. It's possible for the percentage difference from one value to
the next to be less than or greater than the original number.

If value 2 is 20% greater than OR 20% less than value 1, I want to
highlight that row in a table that I created.

Any thoughts on how to write the correct if statement that would yield
this result?

So far I have diff = (value1 - value2) / value1

.5 = (10-5)/10 which is a 50% decrease between the 2 values

Since the percentage difference is greate than 20%, how can I test that
50% in an if statement to highlight this difference for review?

THANKS!

def highlight_difference(value1, value2, close_enough=0.8..1.2)
   return nil if value1.nil? || value2.nil?
   return nil if value1.zero?
   return nil if close_enough.include?(value2.to_f/value1)
   true
end

highlight_difference(10, 5)

=> true

highlight_difference(10, 8)

=> nil

highlight_difference(10, 12)

=> nil

highlight_difference(10, 15)

=> true

-Rob

Rob Biedenharn http://agileconsultingllc.com
Rob@AgileConsultingLLC.com