Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using total, like:
=Sum(Value) / Sum( Total Value)
thank you Tresesco B!