Question

4
Replies
2540
Views
 Balaji Kannadhasan (BALAJIKK)
Cognizant

Cognizant
US
BALAJIKK Member since 2010 1 post
Cognizant
Posted: April 12, 2017
Last activity: April 13, 2017
Posted: 12 Apr 2017 12:11 EDT
Last activity: 13 Apr 2017 10:16 EDT
Closed

Business Day calculation in Report Definition

we have a requirement to show the chart on the dashboard for all the pending cases by considering only the business days (i.e., difference between the Status Update time and the current date time excluding holidays) as shown in the attached file. I do not see any function available for this in RD. Please let know for any possible best solution. using Pega 7.1.8 version

***Moderator Edit: Vidyaranjan | Updated Categories***

Reporting User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 13 Apr 2017 7:59 EDT
Balaji Kannadhasan (BALAJIKK)
Cognizant

Cognizant
US

Thanks for your response. The above urls is again talking about the same problem again. I am still looking forward for the SQL function which calculate the days difference considering only the business days which can be directly used in Report definition or any other better solution. Appreciate your thoughts