davepain Posted May 14, 2003 Share Posted May 14, 2003 any one help?? as an example i have 20 records, within this 2 different products (10 of each) defined by a field (product code) there is 2 other fields cost per unit and sales value per unit. I want to have two summaries of the total or avarage of these two fields for each independent product. Thanks. Link to comment Share on other sites More sharing options...
Peter Fenner Posted May 14, 2003 Share Posted May 14, 2003 What do you mean by: "Sales Value per unit"? Do you mean quantity sold of that product? Pete Link to comment Share on other sites More sharing options...
davepain Posted May 15, 2003 Author Share Posted May 15, 2003 sales value as in sell price, Dave. Link to comment Share on other sites More sharing options...
Peter Fenner Posted May 15, 2003 Share Posted May 15, 2003 If these summaries are for a report then you will simply create summary fields. When creating these summary fields the dialogue box is self-explanatory (ie: Total of...your selected field in dialogue box) On your layout create a new "part". This part will be a sub-summary sorted by product. Place the summary field on this part of the layout. You can also create a trailing (or leading) grand summary layout part. Place the summary field here as well, and you will get the result for all found records, not just product-by-product. You will need to sort your records by product and swop from browse to preview mode to see your end result. If you need to access this result in browse mode, then create a calculation field as follows: GetSummary (summary Link to comment Share on other sites More sharing options...
Newbies toadspittle Posted May 16, 2003 Newbies Share Posted May 16, 2003 I have a similar issue: Small company (2 - 4 workers, depending on project). I'm already using a time billing db to track hours, total hours billed, etc. But I'm creating a project database to track the info. for each project (namely, how long we estimated it would take, how long it did take, what we charged, if it's been paid, etc.). Here's what I need to do: Summarize (from the time billing db) the records for each work entry (i.e., how many hours that employee spent that day on that project), but separated by project and worker. That way we'll know how long each person spent on each project, and what their time cost the client. > GetSummary (summary Link to comment Share on other sites More sharing options...
Peter Fenner Posted May 16, 2003 Share Posted May 16, 2003 I am not sure, but possibly by creating a calculation field that "joins" project and employee id into one field. This then becomes the breakfield. Logically, it should work - but I have very little experience with GetSummary (none in fact). Give it a try though. Pete Link to comment Share on other sites More sharing options...
Newbies toadspittle Posted May 18, 2003 Newbies Share Posted May 18, 2003 Thanks. I'll give it a whirl. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7840 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