thefugeman Posted June 28, 2001 Share Posted June 28, 2001 I 've been working on a report that has a Sub-Summary that sorts by a text field "Designer". I 've got this sub-summary area counting the number of records, designs sold by each designer , etc.. Everything is coming our right except on how to figure *each* designers percentage sold. Two of my fields are a text field called "Sold" which is simply a Yes or No field and a field "Designers Total Sold" that counts the number of Yes's in the "Sold" field. I want to do a simple division between "Designers Total Sold" and "Designers Total Projects Done" to get *each* designers percentage sold. No matter what I try my sub summary gives me the percentage of all designers combine together. How do I get my field to break percentages by each designer. Any help is greatly appreciated... Link to comment Share on other sites More sharing options...
thefugeman Posted June 28, 2001 Author Share Posted June 28, 2001 Hey thanks, Worked like a charm! Link to comment Share on other sites More sharing options...
LiveOak Posted June 29, 2001 Share Posted June 29, 2001 Oh, same question two days in a row! Any time you want to perform a calculation using Summary fields, you need to use the Get Summary (field, break field) function. Your calculation for the subsummary part (it's different for a grand summary) should be: Percent (calculation, number) = Get Summary (Designer Total Sold, Designer) / Get Summary (Designer Total Projects Done, Designer) -bd Link to comment Share on other sites More sharing options...
Newbies kimv Posted July 27, 2001 Newbies Share Posted July 27, 2001 quote: Originally posted by LiveOak: Oh, same question two days in a row! Any time you want to perform a calculation using Summary fields, you need to use the Get Summary (field, break field) function. Your calculation for the subsummary part (it's different for a grand summary) should be: Percent (calculation, number) = Get Summary (Designer Total Sold, Designer) / Get Summary (Designer Total Projects Done, Designer) -bd Link to comment Share on other sites More sharing options...
Newbies kimv Posted July 27, 2001 Newbies Share Posted July 27, 2001 quote: Originally posted by LiveOak: Oh, same question two days in a row! Any time you want to perform a calculation using Summary fields, you need to use the Get Summary (field, break field) function. Your calculation for the subsummary part (it's different for a grand summary) should be: Percent (calculation, number) = Get Summary (Designer Total Sold, Designer) / Get Summary (Designer Total Projects Done, Designer) -bd Hi I have a similar problem and used this with a survey to get percentages: GetSummary(count_How did you hear, How did you hear)/GetSummary(count_How did you hear, Company Affiliation) The two sub-summaries are "How did you hear" and "Company Affiliation", of course. But, only some of the calculations are completed -- the rest show "?". Can I email you the database as an attachment? Link to comment Share on other sites More sharing options...
markpro Posted July 27, 2001 Share Posted July 27, 2001 If it is windows, I'll fix it for you in the AM Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8331 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