Question
CNO Services LLC
IN
Last activity: 5 Jul 2020 9:29 EDT
Calculate difference in business days using function alias in Report Definition.
Hi All,
I want to have a function Alias rule to calculate difference between two dates using BusinessCalendar in Days, so that I can refer function alias in report definition. Kindly let us know if anyone has implemented the same scenario so that it will be helpful to us.
Thanks, Vijay
***Edited by Moderator: Pallavi to update platform capability tags***
Updated: 3 Jul 2020 11:46 EDT
Pegasystems Inc.
US
There is no OOTB function alias to do this. The difficulty is that business days have to take into account holidays.
If this is a SQL function alias, in the past I have done this by manually maintaining a database table containing holidays that a function alias can use to exclude them as business days.
Updated: 3 Jul 2020 11:46 EDT
CNO Services LLC
IN
Hi,
Can i get function alias code that you used for calculating business days. We would like to follow the same approach.
Thanks,
Vijay
Pegasystems Inc.
IN
Hello Vijay,
Hope this link helps in creating the custom alias function in report definition.