Jump to content
Sign in to follow this  
David Jondreau

GetSummary questions

Recommended Posts

I'm creating reports of Line Items. Line Items contains 3 fields: Amount Billed, Amount Paid, and Percent Profit (=1 - AmountPaid/Amount Billed). Line Items also contains 5 fields of Worker, Client, Worker Type, Client Type, and Date.

I want to create reports that will summarize the data for the first 3 fields depending on the sort order of the other 5.

I'm halfway there, but stuck. I've got a single layout, with 5 sub summary parts. I have a summary field for Total Billed, and for Total Paid placed in each of the summary parts.

That all works great. I'm getting the proper summaries depending on the sort order.

It looks like I can't get a true calculation of Percent Profit however without making a calculation field for each of the sort fields. I'm trying to use just one, but a Summary of the Percentage Profit isn't accurate and GetSummary() requires a break field.

Do I need to make a GetSummary() calc field for each of the sort fields or is there a way around this?

Thanks,

DJ

Share this post


Link to post
Share on other sites

Do I need to make a GetSummary() calc field for each of the sort fields or is there a way around this?

As a rule, you need a calculation field for each sub-summary part. However, I think in this case you can get by defining a summary field as the average of profit, weighted by price (untested).

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.

Guest
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.