August 30, 200520 yr 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?
August 30, 200520 yr 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.
September 1, 200520 yr Author 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
Create an account or sign in to comment