Question

3
Replies
48
Views
VijaykumarG6219 Member since 2019 1 post
CNO Services LLC
Posted: 1 month ago
Last activity: 1 month ago

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***  

Pega Platform 7.4 Reporting Insurance
Close popover
Posted: 1 month ago
Updated: 1 month ago

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.

Posted: 1 month ago
Updated: 1 month ago

Hi,

Can i get function alias code that you used for calculating business days. We would like to follow the same approach.

Thanks,

Vijay
Share this page LinkedIn
Copied!