Tally of scorecards

JDWhitmire

We have 23 scorecards with sample data below that we want to roll into a combined scorecard. We started avg each cell for each person and ran into the reference link max for one sheet. When we tried to create a report to tally the average score but the right fields are not showing. Any thoughts would be helpful.

Paul Newcome

Try creating a row report then grouping by item. From there you should be able to use a report summary to get our averages.

Paul Newcome

When you say they right fields are not showing in the report, are they not selectable as options in the "Columns" section of the report builder toolbar at the top?

JDWhitmire

Yes I figured out that I needed to create field on the summary section but that seems a lot of work since we are scoring 30-40 items

Paul Newcome

Try creating a row report then grouping by item. From there you should be able to use a report summary to get our averages.

JDWhitmire

Had to get the right rows and then group them by that row. Thanks for the help.