Page 1 of 1
summarizing fields
Posted: Tue May 31, 2005 4:36 pm
by paula_jhl
Is there an easier way to summarize different characters in a data field? Example: Right now I have a field that can contain 1 character from A-P so I have to count for A^s in that field, then summarize that field and calculate the percentage for A^s in the field and then do the same for B, C, D, E, F, etc...__I have about 20 different fields that I do this for so it becomes quite time consuming.__Thanks!__
=> RE: summarizing fields
Posted: Wed Jun 01, 2005 8:02 am
by kfleming
One thought might be to create a table with a single field that contains the letters of the alphabet. Use this as the master table and then create a scan relation with skip failure action for each field you want to summarize using a flexlink index on that field. You can then group on the alpha field from the master and then create a total for each scanned table.____You then have a matrix that shows the total for each letter from each field.____Kathleen__R&R Support