summarizing fields

[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!__

[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