Skip to main content
Topics#Reports & DashboardsPregunta de Jocelyn Froehlich
Jocelyn Froehlich preguntó en #Reports & Dashboards
10 oct 2012, 20:26

how do I add the age of a lead to the lead report?

how do I add the age of a lead to the lead report?
1 respuesta
  1. Adam Marks (Suntrust)
    10 oct 2012, 20:29
    I have a custom formula field on my lead object with the following syntax:

     

    NOW() - CreatedDate

     

    That calculates the number of days the lead has existed and can be reported on as well.

     

    Edit: Actually I have two fields: One calculates all time and the other calculates based on our criteria of an "open" lead. The "open lead" formula is

     

    IF(OR(ISPICKVAL(Status, "Open"), ISPICKVAL(Status, "Contacted")),ROUND(NOW()-CreatedDate, 0), null)
Escribir una respuesta...
0/9000