Close popover
Saravanan M (Saravanan Maharaj)

Saravanan Maharaj Member since 2010 6 posts
Posted: May 11, 2020
Last activity: June 2, 2020

difference between dates (in minutes) in Report Definition based on business calendar

We have a requirement where we need to display the age of a case (Difference between CreateDateTime and CurentDateTime based on business calendar) in mins in a Report.  There are functions available which can do this. since the report definition only can invoke Function alias rules and there are no OOTB function alias rules available to get this done. 

I have gone through some of the posts in PDN. But couldn't find a solution. one of the link which describes same issue that we have is, but there is no solution in this link too.

Let me explain with an example, Let's say we have business hours mentioned in my calendar instance as 09:00AM to 05:00PM on all weekdays.

Lets assume a case has been created on 7th May 3PM and the case is with status Open and we are running the report at 11AM on 8th May.  then the OOTB function alias (pxDifferenceInMinutes) will give the difference as 20 hours. But what we're actually looking for is, 3PM to 5PM (2 hours) + 9AM to 11AM (2 hours) = 4 hours. Is there a way to do it?

Pega Platform 7.4 Reporting Insurance Senior System Architect SR Exists