Skip to Content
0
Former Member
Jan 27, 2010 at 08:32 AM

Summation Error

20 Views

Hi Experts,

I have data like:

Material Values

A 10,000

B 10,000

I want to add % in next column like

Material Values %

A 10,000 50%

B 10,000 50%

I have used formula "=Values/ Sum(Values) * 100" for percentage.

But Instead I am getting value like:

Material Values %

A 10,000 100%

B 10,000 50%

Note: I have not used "Running Sum" in formula.

Please help.

Regards,

Rishit