Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Count the number of closed opportunties
I want to create a function that counts the number opportunities that are closed for a given month. I also want to show this information on the same saved search that totals the number of all opportunities (open and closed) for a given month. No matter what I do, my value always equals 1. Any help or ideas would be greatly appreciated. Here is my formula
Formula
(Numeric)
Count
case when ( ( {date} >= '1/1/2011' and {date} <= '1/31/2011' ) ) and ( {entitystatus} like '%won%' ) then 1 else 0