Accumulation backwards

[#1]

Hi,

I am trying to accumulate my chart based on below() values instead of the normal above() values.

rangesum(below(count([id]),0,14-RowNo()))

I have to hard code the max number (14) of row in my chart in order to do that.

Is there any way to get the max number of rows? Or is there a better way to do this reverse accumulation without chaing the sorting?

[#2]

can you add a screenshot of what you want to achieve?

[#3]

The code:

rangesum(below(count([id]),0, 14 -RowNo()))

already done what I have wanted, but I do not want to hardcode the number 14 in the code

[Anonymous · Accepted solution]

have you tried the noofrows() chart inter-record function to replace the 14? (I assume 14 here is the number of rows in the chart.

[#5]

Great, it works!

[nizamsha]

=RangeSum(Below(  sum(No),0,NoOfRows()))

Thanks

Jeremy Lai

[#7]

This works better

[#8]

if it will be helpful maybe try function  numsum