jhomer Posted June 23, 2008 Posted June 23, 2008 I think this is an easy one but I cant seem to get out of y own way today. I have a table of shortage causes. there is a summary field counting the occurrences of each shortage type and another field defined as a calculation to get the total # of records defined in this table. I have a corresponding report layout made up of sub summaries. I want to be able to display the types of shortages and show the total number of each and the percent of the total. The summary field takes care of the total # of occurrences but im having trouble defining the percentage calc. Any thoughts?
comment Posted June 23, 2008 Posted June 23, 2008 Try a calculation field = GetSummary ( sCountfield ; Type ) / sCountfield
Recommended Posts
This topic is 6056 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