Newbies wernerf Posted September 11, 2006 Newbies Share Posted September 11, 2006 I'm somewhat of a new user and have a problem that I can use some help with. I have a number field that has a value (marketing cost). This value is specific to a Sales person and added on a monthly basis (the amount changes from month to month). I would like to equally divide this value by the number of jobs (orders) that this person has closed in the particular month. What is the best way to accomplish this task? Thanks! Link to comment Share on other sites More sharing options...
aldipalo Posted September 11, 2006 Share Posted September 11, 2006 (edited) This is the way I would do it assuming Jobs are a separate table related to Sales Rep by Jobs::RepID>SalesRep::RepID. Set up a summary field Jobs::sCount Show Jobs as a portal on Sales Rep layout. In SalesRep set up a calculated field - SalesRep::Average Calc: SalesRep::MarketingCost/Jobs::sCount HTH Sales_Rep.zip Edited September 11, 2006 by Guest Changed Key field and added sample file Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6528 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