Report on sctask table for 10 business days before created date

vivek109
Tera Contributor

Hi,

 

I need to prepare below 2 reports and then calculate percentage using a formula indicator:

I have a catalog item with 2 variables : joining date and target date

1. First report should show all SCTASKS created  10 business days (excluding Sat, sun and holidays etc) before joining date.

2. second report should show all SCTASKS created 10 business days (excluding Sat, sun and holidays etc) before joining date and closed before target date.

 

Please suggest how shall we make such a report, I need to put these 2 reports in a formula indicator to calculate total %.

 

Thanks,

Vivek

0 REPLIES 0