Product instead of summary

[Toni]

Hope this is the right place for this topic.

I am having a little dificculty in finding how to get the product of a given set of found records instead of the summ of them.

When you search a find a set of records you can esaly have the summ of a given field for this set, how about the product of this field?

[comment]

Define a calculation field (result is number) =

Ln ( yournumberfield )

Define a summary field that is Total of the calc field.

Define another calculation field (result is number) =

Exp ( yoursummaryfield )

In version 4 the result will be slightly inaccurate, so you will probably want to round it to 4 - 6 decimal places.

[Toni]

Thanks a lot comment. So this is a mathematical problem rather than a FM related topic. Too bad I had forgot so much on mathematical actions.

regards Toni