Skip to main content
Topics#Data ManagementKim McPeek 的问题
Kim McPeek (TRAK TECOM) 提问于 #Data Management
2017年4月4日 17:46

Win Rate calculation Using #won/#won + #lost

In my org, I have 2 custom check box fields "Is Lost" and "Is Won".  I have a rule set to check the appropriate box when the opp is marked won or lost.  Now I am trying to calculate the win rate% with the following formula "Number won/Number won + Number lost" but the resulting % is in the 100's

 

Here is a screen shot of the results:

 

Win Rate calculation Using #won/#won + #lost

 

Here is a screen shot of the Win rate formula

 

User-added image

 

Thank you in advance for any help you can provide.
13 个回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2017年4月4日 20:11

    Okay, so then you are gonna need to use your custom fields and use 

    ( A / ( A + B ) )

     

     
撰写回答...
0/9000