Skip to main content
Topics#Reports & DashboardsVioleta Roshka의 질문
Violeta Roshka (Salesloft) 님이 #Reports & Dashboards에 질문했습니다
2019년 3월 20일 오후 9:33

reports

Hi, I need help creating a report that shows all activites created by reps divided by the number of reps, trying to show the ratio of activities per sales rep. Thanks!
답변 7개
  1. Sunil Sarilla (M&G Investments)
    2019년 3월 20일 오후 10:23
    Hi Violeta,

     

    you will need a custom formula field and a custom report type to accomplish what you need

     

    create a formula field on the User object

     

    formula return type: number

     

    formula is

    1

    Now create a custom report type with Users as Primary Object

     

    and activities as the secondary object, define the relationship between the objects as A user record must have at least 1 activity record

     

    Create a report using the newly created report type

     

    Group the report by Assigned field

     

    Create a custom summary formula field on the report and formula will be

    Formula_Field__c:SUM/RowCount

    Click on Insert summary field button to select the Formula field and select SUM

     

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