Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Markus_QV
Creator

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?


Inv_Accum_Break_in_Couting.jpg

Best Regards

Markus

1 Solution

Accepted Solutions
jerem1234
Specialist II

Try:

rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))

Hope this helps!

View solution in original post

8 Replies
anbu1984
Master III

Not able to open attached qvw

Markus_QV
Creator
Author

Pls. try the new version...

antoniotiman
Master III

Hi Markus,

try

RangeSum(Top(New#-Done#,1,RowNo()))

Regards,

Antonio

anbu1984
Master III

Try this

Rangesum(New#-Done#,Above([Accumulated]))

jerem1234
Specialist II

Try:

rangesum(New#-Done#, below(New#-Done#, 1, NoOfRows()-RowNo()))

Hope this helps!

Markus_QV
Creator
Author

It's working, but not in the way we need...

we need to start with the accumulation from the oldest date to the youngest....

ScreenShot677.jpg

Markus_QV
Creator
Author

Perfect! That's working...

Thank you very much.....

anbu1984
Master III

Check this