Skip to main content
Topics#Reports & DashboardsShrishty Dhiman's Question
Shrishty Dhiman (Nagarro) asked in #Reports & Dashboards
Jul 19, 2022, 11:08 AM

I want to rename "Age" field in Case Report to "Age (Days)

I have a requirement where I have to create a Report on the standard case object showing the Age of the case till it is closed. I have created the report but the only problem which I am facing is I am unable to rename the Age field

2 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jul 19, 2022, 1:16 PM

    ++ ManojN 

     

    Anothther option using a standard Report Type would be to create a Row-Level Formula(Number) and just insert the standard Case:AGE field, and label it whatever you want.

     

    Or if this is something you're gonna be using a lot across multiple Reports and Report Types you might want to save yourself and your Users some time and trouble and just create a custom Formula(Number) field on the Case Object like this

    BLANKVALUE(ClosedDate ,NOW()) - CreatedDate

    or this

    IF(IsClosed = TRUE, ClosedDate ,NOW()) - CreatedDate
Write an answer...
0/9000