Hi,

In a Report Definition report, you can populate a column of the report using an nested SQL function and Standard functions available in the Pega-RULES:BusinessCalendar library are available which use business day and holiday information.

Standard functions in the Pega-RULES:BusinessCalendar library use business day and holiday information. For example, you can compute the number of business days (based on a specific calendar) between two dates. Business days are sometimes called work days.

If your application includes multiple calendar data instances, a non-business day for some users may be a business day for others.

That being said, consider using a BusinessCalendar function in one of the data columns. Here is a link to a PDN article you might find helpful: https://pdn.pega.com/reporting/how-to-use-nested-sql-functions-in-report-definition-rules.

Thanks,
Abhinav