Apex Code Development You need to sign in to do that
Don't have an account?
John L. Standard Filter for Summary Report of Activities too restrictive
I'm trying to develop a report summarizing Activities by Status. I cannot exclude (or modify) the Standard Filter, which provides the choices to Show 1) Open Activities, 2) Closed Activities, OR 3) Open & Closed Activities. I'd like to be able to show All Activities with *ANY* Status (ie to include Not Started/Deferred, etc.) or the option to disable the Standard Filter entirely.
Can this restriction be circumvented with the Reporting software as it is currently?
Thanks in advance for any help you may provide.
I've found I can acheive the desired information by starting with a Custom Report Type for the Actvity object via Setup + App Setup/Create + Custom Report Type and proceeding from there.
In a related vein, I'm having trouble specifying a Custom Summary Formula to determine Average Aging for an Activity. I tried the following:
AVG( TODAY() - {!$Activity.Created_date} )
but the formula editor doesn't recognize the attribute as I've specified it.
Thanks again in advance.
how about creating an age field on the activity (custom field), then include that in the AVG () formula?