Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

sub summaries?


This topic is 7840 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

  • Newbies

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.