[sims] Adding Net Score to Individual Reports

[ieuan99]

Hi all

 

I've been creating individual reports in Sims for a while now, and adding the behaviour and achievement scores, however my Head Teacher has recently come and asked if we could possibly have the current net score - the achievements minus the behaviour concerns listed.

 

I can't see a field to have this automatically added to the report and the only way I can see to do it would be to run a report of these values, perform the calculation in Excel and then import them to a new aspect, which is alot less efficient than the field automatically staying up to date as it is currently.

 

Anyone got any thoughts on how else I could do this?

 

Thanks

[bobsmith]

Student conduct information - total conduct points

 

This is the total achivements are positive, behaviours are negative.

 

At least as far as I've figure it out so far