08-04-2014 02:54 AM
I need to compare 2 columns(A with B) values and find out the difference in % in next column I used Dif function but giving only count difference is any other function to identify difference in percentage.
|A||B||C(Difference in %)|
I used below code
input A B;
c = (A- B);
08-04-2014 03:21 AM
When you want to work with percentages there must be reference value. With unclear definitions you will not get answers. Answer=42 . (the answer for the ultimtate question).
Percentages are often used with misleading expectations. Suppose you are profits are 100% (on original price) then the correction back new to old is 50% lose.
For the first row the absolute difference is 30 reference for 50 is 60% for 20 that is 150% for an original 100 that is 30% for 70 (the sum) it is 43% for 35 (the mean) 85% . What answer do you like?
Need further help from the community? Please ask a new question.