Sign Up ›
  • HenkHofmans
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
1 replies

Custom Summary Field - Weighted Total

Can one create a simple weighted total in a custom summary field? 
 
I can insert "Annual Sales" as a part of a custom summary field -- it automatically attaches a summary funciton.
ANNUAL_REVENUE:SUM
 
Am I to assume that nothing can be done record-by-record?  How about a really simple weighted sum, counting companies making over $1M?
 
IF(ANNUAL_REVENUE>1000000,1,0)
Error: Field LEAD.ANNUAL_REVENUE does not exist. Check spelling.

Whether I use one of the few fields available or try to use another field from the record (if I can figure out its secret name) it "does not exist".  The only thing that seems to work is arithmetic upon pre-summarized (min/max/sum/avg) fields. 
 
In other words one can do a calculation on a few summarized fields, but one cannot do a summary on a few calculations. 
 
I just want to weight my leads!  I want to count them 0.5 if they have an Inbound Lead_Source and 1.5 for anything else.  What less could you want in custom summary formulas?