- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum not working properly
Hi,
I have a problem with the Rangesum-Function in QV11 and hope someone can help me.
I want to accumulate a column(column(5)), but after some rows have accurately been added , QV is starting in the next row by 0 again (check date 20140606).
(Pls. also see the qvw and the xlsx-file)
Can someone explain to me why that happened?
Best Regards
Markus
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not able to open attached qvw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pls. try the new version...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Markus,
try
RangeSum(Top(New#-Done#,1,RowNo()))
Regards,
Antonio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Rangesum(New#-Done#,Above([Accumulated]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's working, but not in the way we need...
we need to start with the accumulation from the oldest date to the youngest....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perfect! That's working...
Thank you very much.....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this