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?

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

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[kharn101]

I think is solved it, just had to use ABS, is this correct?
Thanks for helping a newbie like me

40	United States	$111,023,400.00	198%	198.00%
30	China	$80,000,000.00	143%	340.91%
20	Russia	$65,000,000.00	116%	457.03%
35	USA	$60,000,000.00	107%	564.21%
7	Korea	$30,000,000.00	54%	617.80%
40	India	$25,000,000.00	45%	662.46%
25	Germany	$22,500,000.00	40%	702.66%
28	Brazil	$22,000,000.00	39%	741.96%
40	Mexico	$18,098,000.00	32%	774.29%
17	France	$15,500,000.00	28%	801.98%
55	Japan	$-100,000.00	0%	801.80%
32	United Kingdom	$-2,000,000.00	-4%	798.23%
46	Chile	$-3,000,000.00	-5%	792.87%
37	Canada	$-4,000,000.00	-7%	785.72%
28	Egypt	$-5,000,000.00	-9%	776.79%
40	United Arab Emirates	$-6,000,000.00	-11%	766.07%
30	Argentina	$-7,000,000.00	-13%	753.57%
50	Poland	$-8,000,000.00	-14%	739.27%
55	Hong Kong	$-10,000,000.00	-18%	721.41%
60	Vietnam	$-20,000,000.00	-36%	685.68%
70	Denmark	$-50,000,000.00	-89%	596.36%
90	Latvia	$-60,000,000.00	-107%	489.18%
19	Slovak	$-80,000,000.00	-143%	346.27%
20	Ukraine	$-100,000,000.00	-179%	167.63%
86	Lithuania	$-150,000,000.00	-268%	-100.33%

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>