Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create cumulative line graph
The data is like
Date Profit Capital
1/1/17 10 100
2/1/17 30 200
3/1/17 40 300
4/1/17 50 400
I want to divide Profit/Capital and want to take cumulative of that as an expression to chart.
Any suggestions?
Hi Sunny,
I want to calculate Column F in the attached sample. Any help?
Thanks
Try this
RangeSum(Above(If(RowNo() = 1, 1, Sum(PL)/Sum(Capital)), 0, RowNo()))