Newbies tnissley Posted January 20, 2005 Newbies 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.
transpower Posted January 20, 2005 Posted January 20, 2005 academic = PatternCount ( checkbox ; "academic" ), etc. Then summary fields for each: sumacademic = ( total of academic ), etc.
Ender Posted January 20, 2005 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.
Recommended Posts
This topic is 7247 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