Looking superficially i'd say you can group this OSAT's.
How about you post a piece of data with fake info?
The goal of the project is to keep the OSAT scores for different products separate.
And I know I'm committing a Forums sin for not uploading the data source, but I'm working from home today without the resources to dummy up the data.
First of all, to answer your original question I think you can just copy the code from [Number of 9s and 10s] into the SUM() in [OSAT %].
With that said, as someone who works almost exclusively with survey data, I would strongly recommend that you restructure your data set to be at the response level (that is, one row per survey response) as opposed to being at the survey level (one row per respondent / survey). Instead of creating a new field for each survey item, you could simply create the following:
[OSAT %] : AVG(IF [Response] = 9 OR [Response] = 10 THEN 1 ELSE 0 END)
This would allow you to have use a single calculated field for all questions.
Couldn't agree more with the response level. A very wise thing and I hope the project moves in that direction.
PS: ..... I knew the calculation was something so simple. Thank you!