Accumulative percentage

[danaleota1]

Hello I'm trying to get a column that returns the accumulative percentage of the frequency columns but the expression is returning a percentage but not the accumulative percentage.  

=Rangesum(Above(sum(Frequency),0,rowNo()))/sum(TOTAL Frequency)

[dplr-rn]

the expression looks correct.
are you using this in a stright table?
can you share some sample data and show whats the output you are getting.

[danaleota1]

I converted it to a pivot table and when I did my expression did work.  Is there a way to do this in a straight table?  Thanks.  

[JordyWegman]

Hi Dleota,

Try this:

Rangesum(Above(TOTAL Sum(Frequency),0,RowNo())) / Sum(TOTAL Frequency)

Jordy

Climber 

[dplr-rn]

use total qualifier in above as well. 

You may need to do total <dimensions> if you want to exclude some