Cumulative product aggregation function

Hi everyone,

I can't find how to perform a cumulative product aggregation. The function I would like to have is:
CumulativeProduct(<Gross Return>+1)-1

Any idea?

Find more posts tagged with

Comments

slievain

The idea is to have the same functionality than with the SUM aggregation function but with the product function.

Any idea would be appreciated.

johnw

Not sure off the top of my head. If you need to write your own, take a look at this article: <a class='bbc_url' href='http://www.ibm.com/developerworks/opensource/library/os-eclipse-birtextpts/index.html'>Using Eclipse BIRT extension points</a>