Shell Programming and Scripting

is there anyway to hardcode the following scenario into the code?

for instance, one line has a value of:

Code:

0.00476979

the next line has a value of:

Code:

-0.0142208

the percentage difference is =

Code:

133.541%

notice it is positive. should be a negative, considering the numbers dropped.

also, what if both numbers are negative:

Code:

-0.0285025

and

Code:

-0.0477696

the percentage difference is:

Code:

40.3334%

should be

Code:

-40.3334%

bipinajith posted a code earlier that can do this. but is there a way to make awk do the proper calculation automatically?

basically if its a drop, the percentages should be negative. if it's an increase, the percentages should be positive.

Code:

awk -F"[=,]" '{prev=$4; print; getline; print $0","($4-prev)/($4<0?-$4:$4)*100"%"}' input

The highlighted part basically does an absolute value of $4.
Note that you'll get into problems if the value is zero (division by zero).