Talent Mgmt - Objectives
I setup lookup "HR_WPM_WEIGHTING" for weighting scale. Values are 5, 10, 15, ----, 100.
Users create objectives and select the weight of each objective from the LOV. If a user has 3 objectives
Weight of Objective 1 is 20
Weight of Objective 2 is 50
Weight of Objective 3 is 30
Sum of weight of all objectives is 100. I am calculating the total score by taking the sum of " perf x weight " and using it to calculate the appraisals final rating.
Users can select the weight of each objective as 100 and for 3 objectives total will be 300. How can I restrict users to enter weight where sum of all objectives weight is equal to 100.