Skip to main content

Nov 19, 2018, 4:30 PM

How can I create a formula that sums the total number of open opportunities?

I want to create a formula field to calculate the number of all open opportunities ( all opportunities except closed) to use in a report that then will have a summary formula column that uses this field opportunity.

Can anyone tell me how to write this formula?

Thank you!

6 answers

Steve Molis (You Owe Me a Beer, Inc.)
Nov 19, 2018, 4:58 PM
I do this type of thing a lot, so on my org I created custom Formula fields that count if an Opportunity is Open

The Formula field is

Field Name = Open

Datatype = Formula

Result = Checkbox

Formula =
IsClosed = FALSE

Add a comment

Write an answer...

0/9000