How to get the total evaluation score and include it in a compensation plan

Content

Hello experts,

I would like to include in compensation plan a column returing the total employee evaluation score calculated as the below example:

(Evaluation Objective A * Weight%) + (Evaluation Objective B * Weight%) + (Evaluation Objective C * Weight%) + (Evaluation Objective D * Weight%) ...

Is there a way to pursue this aim?

Objectives	Evaluation	Weight %	Score
A. _________	3	25	0,75
B. _________	3	25	0,75
C. _________	3	25	0,75
D. _________	3	25	0,75
E. _________			-
	Total	100	3,00

 

Thanks in advance for your time!

Kind Regards,

Valerio