Pareto Analysis help with values

[kharn101]

Good Evening All,
I am having an issue or a brainfart with getting my data to make sense.
The negative and positive values are giving extremely exaggerated total percentages.
Please see my information below. I belive my postive numbers are correct, however my negative
numbers are not making sense. I should be getting a total value of 100% for % of Total Sales.
Can someone help me out?

[TABLE="width: 576"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]S. No.[/TD]
[TD]Country[/TD]
[TD]Total Sales $[/TD]
[TD]% of Total Sales[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]United States[/TD]
[TD] $111,023,400.00[/TD]
[TD]198%[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]China[/TD]
[TD] $80,000,000.00[/TD]
[TD]143%[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]Russia[/TD]
[TD] $65,000,000.00[/TD]
[TD]116%[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]USA[/TD]
[TD] $60,000,000.00[/TD]
[TD]107%[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Korea[/TD]
[TD] $30,000,000.00[/TD]
[TD]54%[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]India[/TD]
[TD] $25,000,000.00[/TD]
[TD]45%[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Germany[/TD]
[TD] $22,500,000.00[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Brazil[/TD]
[TD] $22,000,000.00[/TD]
[TD]39%[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Mexico[/TD]
[TD] $18,098,000.00[/TD]
[TD]32%[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]France[/TD]
[TD] $15,500,000.00[/TD]
[TD]28%[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Japan[/TD]
[TD] $-100,000.00[/TD]
[TD]-100%[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]United Kingdom[/TD]
[TD] $-2,000,000.00[/TD]
[TD]-104%[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Chile[/TD]
[TD] $-3,000,000.00[/TD]
[TD]-105%[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Canada[/TD]
[TD] $-4,000,000.00[/TD]
[TD]-107%[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Egypt[/TD]
[TD] $-5,000,000.00[/TD]
[TD]-109%[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]United Arab Emirates[/TD]
[TD] $-6,000,000.00[/TD]
[TD]-111%[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Argentina[/TD]
[TD] $-7,000,000.00[/TD]
[TD]-113%[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Poland[/TD]
[TD] $-8,000,000.00[/TD]
[TD]-114%[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Hong Kong[/TD]
[TD] $-10,000,000.00[/TD]
[TD]-118%[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Vietnam[/TD]
[TD] $-20,000,000.00[/TD]
[TD]-136%[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Denmark[/TD]
[TD] $-50,000,000.00[/TD]
[TD]-189%[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Latvia[/TD]
[TD] $-60,000,000.00[/TD]
[TD]-207%[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]Slovak[/TD]
[TD] $-80,000,000.00[/TD]
[TD]-243%[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Ukraine[/TD]
[TD] $-100,000,000.00[/TD]
[TD]-279%[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Lithuania[/TD]
[TD] $-150,000,000.00[/TD]
[TD]-368%[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Total Spend[/TD]
[TD]-$55,978,600.00[/TD]
[TD] -1600%[/TD]
[/TR]
</tbody>[/TABLE]

 

[kharn101]

I think is solved it, just had to use ABS, is this correct?
Thanks for helping a newbie like me
[TABLE="width: 663"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]40[/TD]
[TD]United States[/TD]
[TD] $111,023,400.00[/TD]
[TD]198%[/TD]
[TD]198.00%[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]China[/TD]
[TD] $80,000,000.00[/TD]
[TD]143%[/TD]
[TD]340.91%[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Russia[/TD]
[TD] $65,000,000.00[/TD]
[TD]116%[/TD]
[TD]457.03%[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]USA[/TD]
[TD] $60,000,000.00[/TD]
[TD]107%[/TD]
[TD]564.21%[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Korea[/TD]
[TD] $30,000,000.00[/TD]
[TD]54%[/TD]
[TD]617.80%[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]India[/TD]
[TD] $25,000,000.00[/TD]
[TD]45%[/TD]
[TD]662.46%[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Germany[/TD]
[TD] $22,500,000.00[/TD]
[TD]40%[/TD]
[TD]702.66%[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Brazil[/TD]
[TD] $22,000,000.00[/TD]
[TD]39%[/TD]
[TD]741.96%[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]Mexico[/TD]
[TD] $18,098,000.00[/TD]
[TD]32%[/TD]
[TD]774.29%[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]France[/TD]
[TD] $15,500,000.00[/TD]
[TD]28%[/TD]
[TD]801.98%[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]Japan[/TD]
[TD] $-100,000.00[/TD]
[TD]0%[/TD]
[TD]801.80%[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]United Kingdom[/TD]
[TD] $-2,000,000.00[/TD]
[TD]-4%[/TD]
[TD]798.23%[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD]Chile[/TD]
[TD] $-3,000,000.00[/TD]
[TD]-5%[/TD]
[TD]792.87%[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]Canada[/TD]
[TD] $-4,000,000.00[/TD]
[TD]-7%[/TD]
[TD]785.72%[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]Egypt[/TD]
[TD] $-5,000,000.00[/TD]
[TD]-9%[/TD]
[TD]776.79%[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]United Arab Emirates[/TD]
[TD] $-6,000,000.00[/TD]
[TD]-11%[/TD]
[TD]766.07%[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]Argentina[/TD]
[TD] $-7,000,000.00[/TD]
[TD]-13%[/TD]
[TD]753.57%[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]Poland[/TD]
[TD] $-8,000,000.00[/TD]
[TD]-14%[/TD]
[TD]739.27%[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]Hong Kong[/TD]
[TD] $-10,000,000.00[/TD]
[TD]-18%[/TD]
[TD]721.41%[/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]Vietnam[/TD]
[TD] $-20,000,000.00[/TD]
[TD]-36%[/TD]
[TD]685.68%[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD]Denmark[/TD]
[TD] $-50,000,000.00[/TD]
[TD]-89%[/TD]
[TD]596.36%[/TD]
[/TR]
[TR]
[TD]90[/TD]
[TD]Latvia[/TD]
[TD] $-60,000,000.00[/TD]
[TD]-107%[/TD]
[TD]489.18%[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]Slovak[/TD]
[TD] $-80,000,000.00[/TD]
[TD]-143%[/TD]
[TD]346.27%[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Ukraine[/TD]
[TD] $-100,000,000.00[/TD]
[TD]-179%[/TD]
[TD]167.63%[/TD]
[/TR]
[TR]
[TD]86[/TD]
[TD]Lithuania[/TD]
[TD] $-150,000,000.00[/TD]
[TD]-268%[/TD]
[TD]-100.33%[/TD]
[/TR]
</tbody>[/TABLE]