Skip to main content
Topics#Reports & DashboardsDenise Schofield の質問
Denise Schofield (HM Insurance Group) が「#Reports & Dashboards」で質問
2021年5月17日 20:09

Year-over-Year Summary Formula

I need to create a formula that will determine the percentage difference by month for year-over-year opportunities.  Within the table, we have the received date. Please provide suggestions on how to develop a formula that will provide the number for this result:  566 opportunities in January 2021 and 671 opportunities in January 2020, therefore, the percentage difference is (16%).  
13 件の回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2021年5月18日 19:14

    Go back and take a look at my Formula

    IF(
    PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE) <> 0,
    (Opportunity.Opportunity__c:SUM
     - 
    PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE))
     /  
    PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE), 
    NULL)

     

    You're miising these  :SUM

     

     
回答を記入...
0/9000