Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Rowno(Total) with rangesum below function

I am having an issue using rowno(total) in a rangesum below function. The following is my expression:

RangeSum( below (sum({<[Cat ID]={'INV_WIP'}>}   balance),0,RowNo(TOTAL)))

The records start out correct and I work from the bottom up, however (See image) when it gets to a certain row it no longer is correct.

The lines are showing what it is currently doing using rownow(total)

At the top of the chart the records are completely wrong. This is a balance sheet so flowing numbers from the bottom to the top is required to get the correct ending balances.

Expression results are covered due to confidentiality.

1 Solution

Accepted Solutions
Not applicable
Author

I was able to get it to work using NoOfRows() instead.

That was my aim, basically a full accumulation, but reversed.  NoOfRows() returns the total rows in the table so it sums everything correctly.

View solution in original post

2 Replies
swuehl
MVP
MVP

Not sure if I understand, the image you attached seems ok to me. Rownumber is continuous and always incremented by one. I don't understand the lines at the right, probably they refer to expression values that your need to hide?

Maybe you need to rethink the use of below with rowno(total), I assume you want to add up all values that are below a certain line, but using rowno() you will miss more and more lines as soon as you get over the middle line.

Not applicable
Author

I was able to get it to work using NoOfRows() instead.

That was my aim, basically a full accumulation, but reversed.  NoOfRows() returns the total rows in the table so it sums everything correctly.