RangeSum not working properly

[Markus_QV]

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

[anbu1984]

Not able to open attached qvw

[Markus_QV]

Pls. try the new version...

[antoniotiman]

Hi Markus,

try

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

Regards,

Antonio

[anbu1984]

Try this

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

[jerem1234 · Accepted solution]

Try:

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

Hope this helps!

[Markus_QV]

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

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

[Markus_QV]

Perfect! That's working...

Thank you very much.....

[anbu1984]

Check this