Question
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***
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
Thanks Kousik, I am still looking for business days calculation that can be used in RD.
Refer:
https://pdn.pega.com/community/pega-product-support/question/business-days-difference-report-definition-rule
https://pdn.pega.com/community/pega-product-support/question/how-calculate-business-days-difference-report-definitaion