How do I created a weight average formula? I have 3 fields that are a certain % (Financial Score 40%, Confidence Score 30% and Strategic Score 30%). Each of these fields can be populated with 1-10 as the work progresses. I need to create a weighted average field for each showing the current %. ie: If I enter 6 into the Financial Score field, how do I calculate the weighted average % of the total 40% of that field?
1 respuesta
You could do this by simply indicating the weight in your formula like as follows:
(Financial_Score__c * 0.4) + (Confidence_Score__c * 0.3) + (Strategic_Score__c * 0.3)
Depending on the field type you may need to add in additional conversion parameters but as long as you are setting a hard weight per field, you could achieve it with something like the formula I posted above.
