Skip to main content
Rori De La Cruz (Wallem) 님이 #Reports & Dashboards에 질문했습니다
I would like to use this in my report, to count the total Physical visits for each Account.

 

We have a task type values (Sales Visit, Meeting, Email, Phonecall, Other). I need help on what formula to use that if the task values are Sales Visit or Meeting it should count as "1". And if the values are Email, Phonecall, Other it should be "O". Anyone who could help me will be much appreciated. 

 

This will be used in my Market analysis Report.
답변 3개
  1. 2017년 5월 18일 오전 7:39
    You can create a number formula field like below and can use that field to identify task type count.

     

    CASE(Task_type__c,

     

        "Sales Visit", 1,

     

        "Meeting", 1,

     

        0

     

    )