How to calclulate a value as a percentage of the whole?

[josephinetedesc]

Hi All

I would like to do the following

NAME	VALUE	PERCENT OF TOTAL
JOHN	3	30%
PAUL	2	305
GEORGE	4	40%
RINGO	1	10%

I am not getting the correct value with the following

=(Value / Sum({1} Value)

but I get 100% for John, Paul, George and Ringo - rather thanthe 30% etc!

Thank you

Jo

[tresesco · Accepted solution]

Try using total, like:

=Sum(Value) / Sum( Total Value)

[josephinetedesc]

thank you Tresesco B!