Calculate average and then round to nearest whole number
Hey I asked this question before but I was a little confused on the exact way to enter the calculation.
I am calculating student grades and I have a group of fields that are being averaged but then I would like the calculation to also round them to the nearest whole number.
What exactly do I need to have in my calculation formula box?
Final grade: (Average/Rounded)
Are 4, 3, 3, 4 the values to be averaged?
Are they fields in the same record?
If so, then Average ( Attendance; Participation; Assignments; Tests )
Would compute the average. You can use data formatting to display the rounded value or you can use:
Round ( Average ( Attendance; Participation; Assignments; Tests ) ; 0 )