I have a column named daily return, eg: 0, 0.1, 0.2, 0.3… I’d like to calculate accumulative total, base is 1, next is 1 * (1 + 0.1) = 1.1, 1.1 * (1+0.2) = 1.32, 1.32 * (1+0.3) = 1.716, that is every value is based on previous value. the attached image is vivid to illustrate my confusion.
thank you in advance for giving me a hand.
Thank you for writing to us.
We are glad to announce that accumulative total was added as a new aggregation in our latest release. Just update to the latest version and select Running Totals aggregation in the Field List.
Hope it helps.
after I choose Running Totals in the pop up window, as the attachement show. I seems what it do is just an accumulate sum. my case is a little complicated. I’d like to calculate next value based on last value by applying a custom formula. eg: Bn = Bn-1 * (1 + x) .
can you support this?
Currently, it is not possible to implement such a case with the existing functionality.