Cumulative Sum by Field Values

[MalcolmCICWF]

In my below example I am able to create incremental % by each  PoolPlusId and by number of months, this expression is sum(PaymentAmount)/sum(FaceValue)

My cumulative is working but actually doing cumulative across PoolplusID. Cumulative should start over at the .01% for Month 0 of DELQ 1218, then add the cumulative as it goes up through the next PoolPlusId. This is what I'm using now... maybe I can modify?  RangeSum(Above(TOTAL sum(PaymentAmount)/sum(FaceValue), 0, RowNo(TOTAL)))

[rubenmarin · Accepted solution]

Hi @MalcolmCICWF, maybe using "months+1" instead of "RowNo(TOTAL)", at least on the table this may work.

[MalcolmCICWF]

Jesus, that was simple... Didn't know it was that easy. Thanks!

[MalcolmCICWF]

Hey so I noticed in the 1st month, it isn't summing the first percent, it looks to be starting at row 2. I'm trying to adjust the row but cannot... ideas?

RangeSum(Above(TOTAL sum(PaymentAmount)/sum(FaceValue),0, months+1))