I have a requirement for a report that needs to calc a time period in Days (now just simply subtracting the two needed dates). Is there a way to change the calc using the COGNOS Impromptu functions to exclude the weekend days in the total?
(i.e., if case took 5 calendar days to complete (Thurs through the next Mon.), it makes more business sense to show that it only took 3 by recognizing that the period spanned a weekend and subtracting those two days.)
I can kinda already see what would be involved, but I would like to see if anyone else has made this type of process (since I don't want to have to reinvent the wheel...).
My search continues...
Thanks!
Sam Stengler
(i.e., if case took 5 calendar days to complete (Thurs through the next Mon.), it makes more business sense to show that it only took 3 by recognizing that the period spanned a weekend and subtracting those two days.)
I can kinda already see what would be involved, but I would like to see if anyone else has made this type of process (since I don't want to have to reinvent the wheel...).
My search continues...
Thanks!
Sam Stengler