
Contributor II
2017-02-16
05:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
where PLAN is the column to accumulate. This is what I get:
It dosn't seem to want to pick up any previous values. Any ideas?
Thanks!
2,094 Views
1 Solution
Accepted Solutions

MVP
2017-02-16
09:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have more than one dimension? May be this
RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))
3 Replies


Partner - Specialist
2017-02-16
07:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's weird, I can't tell what's the error in you case.
Review the enclosed file. It works just fine.
1,932 Views

MVP
2017-02-16
09:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have more than one dimension? May be this
RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))

Contributor II
2017-02-17
12:01 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this worked. Not sure why, but it did! Thanks!
1,932 Views
