Skip to main content
Topics#Reports & DashboardsKatie DiMento의 질문
Katie DiMento (Wiredrive) 님이 #Reports & Dashboards에 질문했습니다
2013년 8월 9일 오후 7:50

Finding the % of Opportunity Carry Over From Month to Month

Ok, so here goes nothing... I am trying to create a report/formula that can tell me the # and % of Open Opportunities that are carried over from the previous month or months.  To explain further, we want to take groups of Opportunities and determin based on the Created Date and Average Age how many Opportunities that come in in a particular month are still open and being worked the following month or months.

 

For example, an Opportunity that comes in in March that is not closed until April or even May. We want to know the # and % of Opportunities that are carried over from the month they come in to following months. So maybe 75% of our Opportunities close in the month they came in, and 25% of Opportunities carried over and closed in the follow month.

 

Does this make sense?

 

Thanks a billion! This will be extreamly helpful if we can figure this out. :)
답변 2개
  1. David K. Liu (Google)
    2013년 8월 9일 오후 11:34
    Sorry some additional info:

     

    Basically PREVGROUPVAL() lets you compare a summary result from the previous group of a summary report!

     

    So if you had a summary report summarized by month, you could compare a current month's summary result with the previous month's.

     

    Hope this helps!

     

    David
답변을 작성하세요...
0/9000