Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
Hi @MalcolmCICWF, maybe using "months+1" instead of "RowNo(TOTAL)", at least on the table this may work.
Hi @MalcolmCICWF, maybe using "months+1" instead of "RowNo(TOTAL)", at least on the table this may work.
Jesus, that was simple... Didn't know it was that easy. Thanks!
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))