Please go through pxDifferenceInDays Function Alias and customize as per your requirement .

There’s no OOTB way you can do it ,you have to write your own sql function to get the desired report .

Thanks,

Arun

HI,

Below link might help you.

https://collaborate.pega.com/question/business-day-calculation-report-definition

You can follow below approach.

Create a property, add a declare expression to it and expose this property in your table.

Now use "differenceBetweenDays" function to calculate days difference in the declare expression logic.

Using this property in your definition to satisfy your requirement.

You can follow below approach.

Create a property, add a declare expression to it and expose this property in your table.

Now use "differenceBetweenDays" function to calculate days difference in the declare expression logic.

Using this property in your report definition to satisfy your requirement.