Calculating Residuals in AM7
I am planning on setting up templates to calculate residuals when the results come out in August, I'm using last year's data to have a play.
I've done RESULT - APS in one review column then another to divide by 6 to get the residual. However, when the result of the review column is negative, dividing it by 6 then puts it back to positive which is obviously a problem. Same thing occurs for Value Added.
Is there a way round this? I don't want to go back to Excel as we have done in previous years. Ideas/suggestions welcome!!