Toni Posted August 30, 2005 Share Posted August 30, 2005 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? Link to comment Share on other sites More sharing options...
comment Posted August 30, 2005 Share Posted August 30, 2005 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. Link to comment Share on other sites More sharing options...
Toni Posted September 1, 2005 Author Share Posted September 1, 2005 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6667 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now