Is there any way I can use a formula column in SIMS to return the highest result for each pupil from 2 columns. I have been messing about with the MAX formula column but can't seem to get it to work with that.

Printable View

- 13th December 2013, 03:12 PMXeba37SIMS.net Calculating the highest of several results
Is there any way I can use a formula column in SIMS to return the highest result for each pupil from 2 columns. I have been messing about with the MAX formula column but can't seem to get it to work with that.

- 13th December 2013, 03:21 PMLosOjos
Hi @

__Xeba37__:welcome:

The MAX formula should work, you just select the columns to look at, then enter the rank (i.e. 1 for best) in the "Max" box. If you're doing this with grades, check that the points are correct for the gradesets those aspects are linked to and finally, remember to hit "Calculate" on the marksheet :) - 14th December 2013, 10:34 AMdavidpott
Remember that if you use a MAX formula against a set of grade columns, the formula will return the points score value of the grade, not the grade itself (eg if the highest grade is a C you'll get 40). You'll then need to use a 'marks to grade' formula to convert the points score back into its grade.

- 17th December 2013, 11:54 AMXeba37
Yeah I was aware of that but have not figured out how to convert it back without using 2 'Nested if then else' formula columns which seems like a long way round. I think I'd be quicker doing la lookup in Excel and importing my converted results than going down that route.

- 17th December 2013, 12:01 PMLosOjos
- 17th December 2013, 12:14 PMXeba37
- 18th December 2013, 11:47 AMXeba37
Forgive me for being an idiot, but how can I make the marks to grade column work when it seems to want an aspect selecting. I have used a MAX column to pick out the highest grade so far so my APS is in that.

- 18th December 2013, 05:03 PMdavidpott
The aspect it is asking for is the aspect that will contain the final, converted, grade. For example if you have set up an aspect to hold the highest grade out of a range of grades, then that's the grade you should enter here. It will then ask you to identify the column that contains the marks that need converting. Point it at the column that holds the MAX formula and it should work! Marks to grade formulas take a bit of getting used to but they do save a lot of time and effort in Excel.

David. - 19th December 2013, 08:14 AMXeba37
I ended up doing a lookup in Excel and importing it, I think because I had so many aspects to deal with it was quicker that way anyway. Thank you though, I will bear that in mind for future work.