alexhulse2

(Trick nicked from SupportNet but a good one!) Useful trick if you have a column in AM7 that could contain a grade but could also contain a blank, but you want to be able to run if then else or nested if then else against it reliably. If you create a formula column called Zeroes with EQUALS with 0 as the constant, you can then create a further column that SUMs the Zeroes column and the grades column and it will give you the value of the column if there's a grade, or a nice reliable 0 if there's nothing. I've found that ITE or NITE can be fussy about blanks and produce odd results, so being able to compare with an actual 0 can be useful.

@tombry No, you're not being thick! As you say, the FSM column only shows currently FSM students (I think), as historically that's all that was required. Hopefully Capita might expand this in the future *nudge, nudge, wink, wink* to have an Ever6 column too, as the currently mooted solution of a Pupil Premium tick box that the school needs to manually maintain sounds like it could go wrong quickly. If the DfE are basing PP on Ever6 FSM, Ever3 Service Child and LEA In Care, hopefully SIMS can piece this together on its own, as it should contain all the necessary information? @PhilNeal Possible, or too simplistic? DfE PP Condition of Grant 2013-14 http://media.education.gov.uk/assets/files/pdf/p/pupil%20premium%20conditions%20of%20grant%2013-14.pdf