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 !!
You need a total in Above as well and 0 as the starting index to include the current row in the cumulative value:
=Rangesum(Above(Total Sum({$<[LVR.Date d_expédition] = {">=$(vStartDate)<=$(vEndDate)"}>} LVR.Montant), 0, rowno(Total))) / 1000