Hi there

I want to do something like this in formula field.
I want to calculate average on specific records on my reports. This is for calculating average grades of students.
I want to do like this:
If {course.courseName}(i)={course.courseName}(i+1) then
GradeMax=max{grades.grade}
This code is for incorporating the max marks of each student in each course.

I want to separate the specific grades of each student for other weighting (such as .05):
This is the code I want to do:
If {course.CourseName}="Math" then
Math2=math*0.5
I want to use this number for calculating overall average.

Lastly for calculating the overall average I want to calculate other grades averages and then multiply by these specific numbers:
Average=grademax+math2+otherGrades In recordes/recordsNum

How can I do something like this in Crystal report?

Thanks for any helps