### Title

Calculation result by a value in a field

### Post

This is a calculation that returns an average of the scores. I need another field that would return the same value except based on a field *quarter* when *quarter* is equal to 1,2,3 or 4

Let ( [ Q = GetSummary ( SumAverageQuiz ; SumAverageQuiz );

T = GetSummary ( SumAverageTest ; SumAverageTest )

];

Sum (Q ; T) / Count (Q;T )

)

Get summary does not need to be used in your example. When you repeat the summary field as your break field, you get a grand total type result--which is the same as if you used the summary fields in your calculation without using getsummary at all.

Let ( [ Q = SumAverageQuiz ;

T = SumAverageTest

];

Sum (Q ; T) / Count (Q;T )

)

Should produce the same result as far as I can tell.

How will the value of "Quarter" affect your results? Do you intend to sort your records by quarter to group them by all records for the same quarter so that your calculation computes this value just for one quarter for each group of records from the same quarter?