Hi - Is there any way to do a cumulative sum?
e.g. in QLIK Sense I can do
rangesum(above( sum(BaseTotalPL), 0, rowno() ))
and what this does is give me a cumulative sum for every row.
Why would I want this? Very simply: I need to be able to show cumulative P&L day by day. e.g. $10 on 1/1, $20 on 1/2, so I would show $10 on 1/1 and $30 on 1/2.
In addition I need to show geometric cumulative ROR day by day, which could be expressed as sum of logarithms.