I try to set up a report where I see a hit rate per sales person and his opportunity pipeline in percentage. I already figured out how to display the amount of win and lost opportunities but now i need a calculation of these both and display the hitrate in percentage in a column.
Can anybody assist me how to do that?
Thank you so much already in advance!
BR
Manuel
7 件の回答
Hello,
if for you hit rate is closed won /(closed won + closed lost) and you want this score :
you should create this formula :
the formula : WON:SUM/RowCount
Ps : it is one of my first contribution, if I helped you, please reward me with a best answer :)
