ShowAll Questionssorted byDate Posted
Nidish G 6

# We need custom field on Account which holds the count of closed won opportunities of that particular account for current year

We need 3 custom fields on Account object:
1. Count of Closed Won Opportunities for Curent year
2. Count of Closed Won Opportunities for current quarter
3. Count of Closed Won Opportunities for current month
kamala swarnalatha
Hi Nidish,

1.First you have to create three text fields to capture the current month, current year, and current quarter.
Then use the workflow rule to update based on the formulas as follow
a.Criteria:  YEAR(Close Date)=YEAR(Today()) then Current year=1
b.Criteria: MONTH(Close Date)=MONTH(TODAY()) then Current Month=1
c.Criteria: AND(CEILING(MONTH(Close date)/3)=CEILING( MONTH(TODAY())/3), YEAR(Close date)= YEAR(TODAY())) then Current Quarter=1

2.Second you have create three Roll up summary based on this above text as
1. Count of Closed Won Opportunities for Current year
Count of Opportunities based on Won=True & Current Year=1
2. Count of Closed Won Opportunities for current quarter
Count of Opportunities based on Won=True & Current Quarter=1
3. Count of Closed Won Opportunities for current month
Count of Opportunities based on Won=True & Current Month=1