can I add custom formula to web data rocks
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.