### Browse by categories

- All
- Collaboration
- Configuration & Data Management
- CPQ and Billing
- Customer Service & Support
- Desktop Integration
- Einstein Analytics
- Email Marketing
- Journey Management
- Mobile
- Mobile Messaging
- Packaging, Uploading & Installing Apps
- Reports & Dashboards
- Sales & Marketing
- Security
- Social Marketing
- Trailhead Challenges
- Additional Products

# Creating a Win Loss Percentage Formula in a Report using Stage

I have been tasked with creating a new report for sales that calculates their win rate on a report that shows:

Total Created Opportunities

Won

Lost

Win Loss%

We dont use standard stages here. We use Closed Lost = 0% and Onboard Complete = 100%

Any help would be appreciated!

Thanks in advance.

Kathleen

Kemi Le-

When you edit your formula, you should be able to pick where the formula will be displayed. that's where it is going to summarize the numbers. Do you have them set to Grouping 1? You can pick All Summary Levels and you will see the totals at the bottom as well as in the groups.

## All Answers

Kemi LeHi Kathleen,

You could try something like this:

Create a summary opportunity report and add formulas using the WON standard field.

Total Won (number format) = WON:MAX

Total Lost ( number format) = RowCount-WON:MAX

Win Loss % (percent format) = WON:SUM/RowCount

To get total, just summarize one of the columns, but if you are hiding details and you want to show this in line with your other formulas you can do a number formula and summarize RowCount.

Just make sure to create your formulas in the order you want to see them on the report, from left to right.

You would have something like this:

Steve MolisHere's a report and some CSF's the I built to calculate Close Rate and Win Rate ->

2

3

Kathleen VanHooserHi Kemi,

Thank you so much for the response! I appreciate it.

I don't have standard won fields that I can see.

I do know 100% = complete

and 0% = loss

How would I write this as a formula in the report using the same scenario below.

Here is a screen shot of the report

Kemi LeHey there, I see it in your field chooser on the left - it is the 12th one down I think - it shows # Won. Right before Close Date. the # isn't part of the field name - it's there to show what type of field it is. Kathleen VanHooserKemi,

Thank you so much! I am getting closer. I created the 3 formula fields that you advised. The only problem is the numbersare not totaling at the bottom.

I am not sure how to summarize them?

Also does that Win Loss Rate Look Correct?

Here is a screen shot:

Kathleen VanHooserThe numbers for total won and lost are not correct when I drill down to the detail.

What am I doing wrong?????

Kemi Le

Ahh, sorry I had errors in my formula. Use these.

Total Won (number format) = WON:SUM

Total Lost ( number format) = RowCount-WON:SUM

Win Loss % (percent format) = WON:SUM/RowCount

For your summary level grouping make sure you have it set for all summary levels. This will summarize at the bottom as well.

Kathleen VanHooserYou are a doll! That worked. Thanks so much!

One more thing though....I dont understand what you mean by summary level grouping?

Where do I put those? I know how to summarize a field, but am unable to on these custom formula fields.

I appreciate your help very much!

Kathleen

Kemi Le-

When you edit your formula, you should be able to pick where the formula will be displayed. that's where it is going to summarize the numbers. Do you have them set to Grouping 1? You can pick All Summary Levels and you will see the totals at the bottom as well as in the groups.

Kathleen VanHooserI saw that....after I typed you!

You are wonderful!!

Kemi LeGlad I could help! Steve MolisKathy, Show a sister some love and mark Kemi's solution as "Best Answer"

Kathleen VanHooserDone!

Thanks, I am new to using "answers."

Steve MolisKathy, you still haven't marked Kemi's solution as "Best Answer" Kathleen VanHooserSteve,

I thought I did.

I am new to using the community. I clicked on most helpful...what else am I supposed to do?

Thanks

Steve MolisIf someone posts the solution to your question then you should click " "Mark as Best AnswerKristine DenzonDefinitely the Wonderful Best Answer! May I ask how I can be able to show the Win/Loss % in the Dashboard? I have been trying but the option to select win/loss% is not available. I am not really sure if this is possible. Thank you so much!!!! Andreas SlovacekThese answers are all excellent! Can anyone link me to documentation on the "WON," "CLOSED," "RowCount" fields? Thank you in advance!

Malik ZeeHello,

Thanks for this thread, I'm trying to create a Win/Loss report and am inching closer.

Question - my "Won/Closed" fields display as checkboxes instead of an actual value, how can I change this and does this make a difference when trying to create the Win/Loss report?