Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
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,
)
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
Hi ! Thanks for your speed answer but the twice function that you give me made "0" everywhere...
Hi I am attaching QVW ..this might help u..
sample data..sample screen shot..
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
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,
)
Hi, the same result like before
thanks a lot
Please post your sample app
have you tried the expression which I suggested? what values you are getting using that?
Oh that works sorry i tried your expression and that seem to be ok
thanks a lot KUSH !! So much!!