% of Opportunity Closed Won Amount of All Opportunity Amount - Salesforce Report - Answers - Salesforce Trailblazer Community
ShowAll Questionssorted byDate Posted
Merlinda Lu

# % of Opportunity Closed Won Amount of All Opportunity Amount - Salesforce Report

I have a Salesforce report that shows 1) the total Opportunity Amount of all Closed Won Opportunities, and 2) I have the total Opportunity Amount for all Opportunities in other stages (anything except Closed Won). I am trying to figure out how to create formula field that will give me the percentage of the total Opportunity Amount for Closed Won only compared to Total Amount of all Opportunities in all stages including Closed Won.
Best Answer chosen by Merlinda Lu
Steve Molis
Here you go
```Opportunity.Amount_Won__c:SUM
/
AMOUNT:SUM```

Steve Molis
I have to do that sorta thing a lot on my org.  So much so that I created custom Formula(Currency) fields on the Opportunity Object like this

Field Type = Formula
Formula Result  = Currency
Formula =

\$Amount(Won)
`IF(IsWon = TRUE, Amount , 0)`
\$Amount(Open)
`IF(IsClosed = FALSE, Amount , 0)`
\$Amount(Closed)
`IF(IsClosed = TRUE, Amount , 0)`
\$Amount(Lost)
```IF(
AND(
IsClosed = TRUE,
IsWon = FALSE),
Amount ,
0 )```

Steve Molis
PS.  Otherwise you could create a Row Level Formula, but then you're stuck at the Row Level, which is a bit umm... limiting
Merlinda Lu
Hi Steve,

Thanks for your quick response. So with those custom formula fields created, what would the formula be on the report to show the % of \$Amount(Won) compared to total amount of all opportunities?

```Opportunity.Amount_Won__c:SUM