Newbies compass53 Posted May 30, 2005 Newbies Posted May 30, 2005 How do I easily count items in a value list? I have been using an IF statement field like: if "item" 1,0. Then I use a summary field to sum the counted items. This makes 2 fields per counted item, which really uses up space. There must be an easier way to do this.
Vaughan Posted May 31, 2005 Posted May 31, 2005 A value list is a list of values, paragraph separated. The number of values in a value list equals the number of paragraphs in the list, plus 1. PatternCount( ValueListItems( Get( FileName ) ; "valuelistname" ), "" ) + 1
Newbies compass53 Posted June 1, 2005 Author Newbies Posted June 1, 2005 Thanks, I'll give the suggesions a go. Ray
Recommended Posts
This topic is 7116 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