July 6, 200421 yr Possible? How? -or is it possible to count based on a field meeting a specific criteria (containing a specific value, not just any value)?
July 6, 200421 yr Howdy! I'm not sure I follow exactly but you may want to look at these and see if these will help solve your problem... Status (CurrentFoundCount) -- this gives you the number of records in your found set summary fields... (count of field x) -- this gives you the number of records in the found set for which field x has values PatternCount -- this counts the number of occurances of a string in a body of text --ST
July 6, 200421 yr Author but what if i want to find how many currently found records have a value of "y" for "field x"...sorry for the poor explanation
July 6, 200421 yr Hmm... I have not use it before, but the GetSummary function may work for you in this situation. GetSummary Help has as an example... GetSummary(Total Sales, Country) returns a summary of all records pertaining to the value in the Country field. Either that, or you can create a calc field y_specific that only has value if y=specific and then use a summary field that counts y_specific instead, I suppose... kinda weak if there's several but it should be okay if it's just that 1 criterion. I'm sure there's better ways of doing this... probably having to do w/relationships and self-joins and what not which are still kind of fuzzy to me. Ah, well... not really my area of expertise, but I hope this helps. --ST
July 6, 200421 yr Author thanks. ya, i'm not entirely familiar with relationships and summaries, so i've started doing it the long way with calculations and totals. thanks for the help
Create an account or sign in to comment