Cumulative by each Unique Record

[MalcolmCICWF]

I am trying to  create a Cumulative expression that is off of the incrimental per Example column. I can get it to do cumulative of the entire column, but Not for Example A and then start over on Example B. Is there a group by function I can write in the expression itself?

This is what I was trying to use. The PaymentAmount is what I divide by the Facevalue (per Example) to get Incremental %. But I'm wondering if I can just do it off the Incremental column itself as a reference.

RangeSum(Above(TOTAL Sum(PaymentAmount), 1, RowNo(TOTAL)))

[chrismarlow]

Hi,

Above/RangeSum do recongnise the change on the first column, so might the following work;

RangeSum(Above(Column(3), 0, RowNo()))

So as below;

Cheers,

Chris.