Lookup Table not working

[mdwheeler]

Hi,

 

Maybe I am going about things in the wrong way! I would like to turn % into grades for a set of marksheets. I know there is a % to grade formula but it seems incredibly clunky to use as I have 10 tests convert on a marksheet and I have to type in the grades manually each time (or produce a different set of gradesets for each subject and year group). So I thought I could use a lookup table for each subject as in the enclosed example. However, when I try and use this to put data into any aspect (marks/decimal, marks/integer/ grades) I get nothing. I use a column containing %s which is of type marks/decimal as the source for the calculation. I cannot see where I am going wrong? But it is probably something dumb on my part.

 

Thanks

Martyn

 

[coolhands]

I haven't read your thread in detail but check here it walks you through it, you might spot something. I can't see a 'Gradeset' in your screenshot so could it be that?

 

https://davidpott.com/2014/07/01/using-sims-convert-new-gcse-grades/

[mdwheeler]

Hi Thanks,

I have added more columns onto my lookup table and it is now producing some data. However, the data is being pulled from the wrong age column! A pupil who is 15 y 02 m is getting data from the 11/01 column??