Jump to content
Sign in to follow this  

Calculation Help

Recommended Posts

Hi All,

I have a database that tracks sales per sales person per year. All records per company are in a specific "year" field. I have built the first sales person to say If(Year = "2008" and Salesperson = "Brian"; Cost;" "). Now I have create that same field for each year (also adding summary fields per item able to be sold (approx 10) which comes to about 10-15 fields per salesperson (5) per year. Is there an easier way to get this information without having to build all these fields? I am creating a summary Report that will show per sales person, per year, a breakdown of all their sales for that year. Thank you in advance for any help!

Share this post

Link to post
Share on other sites

Let's say you have a table with these fields:

Year, Salesperson, Item, Cost

Make a summary field for total of Cost.

Make a layout with subsummary parts for Year, Salesperson, and Item, sorting in that order as well.

Put the summary field on each part.

All done.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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