Newbies tnissley Posted January 20, 2005 Newbies Share Posted January 20, 2005 I am trying to get a total figure for each of 4 choices of a value list. I can't sem to get it to work. For example my value list is called types of concerns with the four choices of 1) academic 2) behavior 3)attention 4) emotional. I have 355 record with each record having one of those four choices in the record. I want to see have many I have of each type. I know it can't be as hard as I am making it. Link to comment Share on other sites More sharing options...
transpower Posted January 20, 2005 Share Posted January 20, 2005 academic = PatternCount ( checkbox ; "academic" ), etc. Then summary fields for each: sumacademic = ( total of academic ), etc. Link to comment Share on other sites More sharing options...
Ender Posted January 20, 2005 Share Posted January 20, 2005 If this is just for preview or print, add just one summary field: Count of Records (Summary) = Count of RecordID Then use a Sub-Summary by Type of Concern part (instead of a Body part) in a list view. Insert the Type of Concern field and Count of Records field on this part, sort it by Type of Concern, and print or view it in Preview Mode to see the results. The advantage of this method is you don't have to have new fields for each value list choice. There is also a method of creating a file for the value list choices, but that's probably more than you need for such a short value list. Link to comment Share on other sites More sharing options...
Newbies tnissley Posted January 21, 2005 Author Newbies Share Posted January 21, 2005 Thanks for your help Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7034 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