Cumulative Max

[DavideProtasi]

Hi Guys,

could you suggest me on how to get a cumulative max on front end?

In the example table below I'd like to get the fourth column (Cumulative max).

ID	Amount	Cumulative Sum	Cumulative Max
1	14	14	14
2	5	19	19
3	-5	14	19
4	8	22	22
5	-15	7	22
6	23	30	30
7	11	41	41
8	-9	32	41
9	-7	25	41
10	15	40	41

Thank you very much 

[SP2412]

Try RangeMax so something like RangeMax(Above(Max(Amount), 0, RowNo()))