cumulative sum

[#1]

Hi,

i want to do a cumulative sum by month but i don't know how to do this,

i try the rangesum function but it dont work...

The CA field is this expression : Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000

How can i do this? Thanks a lot !!

[er_mohit]

Hi try this

Rangesum(Above(Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant),1,rowno(Total)))/1000

or try this

Rangesum(Above(Sum(LVR.Montant),1,rowno(Total)))/1000

[#3]

Hi ! Thanks for your speed answer but the twice function that you give me made "0" everywhere...

[#4]

Hi I am attaching QVW ..this might help u..

sample data..sample screen shot..

[#5]

Thanks a lot Narendra .. but

So i try this :

Rangesum(Above(Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant),0,rowno()))/1000

as you can see that don't give me cumulative

I try Rangesum(Above(Sum(LVR.Montant),0,rowno()))/1000 but it doesen't work too

[Kushal_Chawda · Accepted solution]

try ,

=RangeSum(above( Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000,1, RowNo()),

Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000,

)

[#7]

Hi, the same result like before

thanks a lot

[Kushal_Chawda]

Please post your sample app

[Kushal_Chawda]

have you tried the expression which I suggested? what values you are getting using that?

[#10]

Oh that works sorry i tried your expression and that seem to be ok

thanks a lot KUSH !! So much!!