Skip to main content
Topics#Data ManagementWillie Mullen's Question
Willie Mullen asked in #Data Management
Jul 4, 2012, 2:03 AM

Weighted Average Calculation

I need a field on my Account Object called "Total Worth" that needs to be the product of (a) Average of Field Y for all Open Opps (times) X (b) Average of Probability % for all Open Opps.

 

EX: Opp1 has Field Y of $150 with 25% probability. Opp2 has Field Y of $275 with 45% probability. My formula field would calculate:

 

(150+275) /  2 = 212.50

 

(25%+55%) / 2 = 40%

 

212.50 * 40% = $85

 

$85 is my end goal - help me get there! And this is only for Opportunity Type's Z.

 

Thanks!
1 answer
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jul 4, 2012, 2:26 AM
    You could probably do this by creating Roll-Up Summary (RUS) fields to SUM the Amount of Open Opportunities and AVG the Probability% of Open Opprtunities.  Then create a custom Formula(Currency) field that uses your formula  (RUS_Amount * RUS_Probability) 
Write an answer...
0/9000