AnsweredAssumed Answered

How to make a field that is a summary of unique values for multiple fields.

Question asked by jyajj on Jan 15, 2010
Latest reply on Jan 15, 2010 by comment_1

Title

How to make a field that is a summary of unique values for multiple fields.

Post

I have one table that is called "Evaluations" Each Evaluations record has 19 eval fields (evalA, EvalB, EvalC). Each field has one evaluation result from a value list of 7 options.

 

****The reason for keeping all the evaluations as one record is because it relates to a certain item that has those evaluations and certain groups (2 other tables)****

 

My problem is that I want to count how many of each value list option is in each field for each evaluation in a "dyamic" report without having to make 60 calc fields.

 

Example:

 

EvalA I need to know how many of  Value list option1, option2, option3, option4, option 5 for Eval A

 

for Eval B I need to know how many of Value list Option1, option2. option3, option 4, option 5 for Eval B

 

this would repeat for all evals.

 

The table should look something like this.

 

                                  EvalA  EvalB EvalC ......

 

valuelistchoice1total       2        4        6

valuelistchoice 2 total     4        0        3

valuelistchoice 3 total     1        1        2

 

 

Is this possible????   Any help would be great! Thank You

 

Outcomes