I have a query with a calculated column (CompRest). CompRest will either be zero or a figure. The data is sorted in date order (I do have a column trxSeq which is sequential if that helds). I need another column (CompRestCum) to be equal to CompRest, unless CompRest is zero, in which case I need it to be the last none zero figure. For example of the data see below.
Comp Rest CompRestCum
So it is not cumulative, it simply keeping the last none zero. Thanks for your help.