7 Replies Latest reply: Mar 11, 2015 10:44 PM by anbu cheliyan

# Accumulation - include first row in totals

Hi,

I'm having an issue with my accumulation function. I need it to include the value on the first row as well. Below is the output I am currently experiencing, however what I was expecting to see is in the "Running Total" column - 75.73% on the first row and the subsequent values adding on top of the initial value. Any assistance would be greatly appreciated.

Here is how the columns are being calculated:

Relative Total: sum(count) WITH relative option selected

Total Count: sum(count) WITHOUT relative option selected

Running Total: Above(TOTAL Column(1)) + If(Above(TOTAL Column(3)) > 0, Above(TOTAL Column(3)), 0)

• ###### Re: Accumulation - include first row in totals

Does this help:

if(rowno()=1,sum([Relative Total]),RangeSum (above(sum([Relative Total]),0,RowNo())))

This

is different data set but as you see is working

• ###### Re: Accumulation - include first row in totals

Hi Robert,

• ###### Re: Accumulation - include first row in totals

I'm at home using PE so I can not ask for qvw file unless you can wait till tomorrow when I at work.

But if you can post sample of your data I can look at this again

• ###### Re: Accumulation - include first row in totals

Here is a .csv of the raw data. In the table i'm rolling the data up to Month-Year

• ###### Re: Accumulation - include first row in totals

This works for me

if(RowNo(total) = 1,column(1)/sum(total cnt),

rangesum(column(1)/sum(total cnt),Above(total [Running Total]))

)

• ###### Re: Accumulation - include first row in totals

Thank you for the reply Ramon. Unfortunately using your solution is not accumulating the relative percentage.Is there any other options i need enabled?

• ###### Re: Accumulation - include first row in totals

Running Total: Alt(Above( Column(3)),0)+Sum(cnt)

Running Total %: Column(3)/ Sum(TOTAL cnt)*100