Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rheacock
Contributor II
Contributor II

RangeSum not working in a table

I've been struggling with RangeSum.  I have a simple sorted table that I want to accumulate the values for.  I'm using:

RangeSum field.PNG

where PLAN is the column to accumulate.  This is what I get:

RangeSum.PNG

It dosn't seem to want to pick up any previous values.  Any ideas?

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Do you have more than one dimension? May be this

RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))

View solution in original post

3 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

It's weird, I can't tell what's the error in you case.

Review the enclosed file. It works just fine.

sunny_talwar

Do you have more than one dimension? May be this

RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))

rheacock
Contributor II
Contributor II
Author

this worked.  Not sure why, but it did!  Thanks!