Arranging answers by quarters

[tracycrown]

Dear Sir/Madam

Can someone advise me how to arrange the computed answers in column(3) to respective quarters.

Sno	Quarter	Index	Average by Quarter	Correct Answer
1	1		0.93
2	2		1.02
3	3	1.06	1.04	1.04
4	4	1.01	1.00	1.00
5	1	0.95	-	0.93
6	2	1.00	-	1.02
7	3	1.03	-	1.04
8	4	1.04	-	1.00
9	1	0.91	-	0.93
10	2	1.04	-	1.02
11	3	1.03	-	1.04
12	4	0.96	-	1.00

Thank you

Tracy

[settu_periasamy · Accepted solution]

May be try this..

if(sum(Index)>0,avg(TOTAL <Quarter>Index))

instead of aggregation

[tracycrown]

Dear Mr. Settu_Peroasamy

Thank you so much for your quick response.

Tracy