45276 - no subject - I have a report over around 650 running

joel over 11 years ago

I have a report over around 650 running processes. In one column I am doing the following calculation calworkdays(pv!date,today()) in the majority of cases this works fine, in some cases it does not despite pv!date have a value. The strange thing is if I apply a filter on another column it works fine. Remove the filter and the same cases break. If I change the calculation to today-pv!date, then the whole thing works fine. Any thoughts to why this behaviour might be happening. When I look at the report timing the report is running in 0.112 seconds and the only thing I can see is Case Age(Working Days) (EVAL:@reason=Function calworkdays: domain) in Name column Type: Column (Error) Resources:process-analytics2. Any thoughs...

Discussion posts and replies are publicly visible

Parents

0 joel over 11 years ago

Hi Dinesh, thanks for your reply. I thought it was a data issue at first. My collegue who built the process tells me that data type has never been changed. I also checked they all have values as dateTime, and have tried wrapping the pv! in a todate() expression with the same result. The bit that really confuses me is that if I reduce the cases via a filter it works fine, remove the filter and the same cases break! I also tried networkdays() and this causes the same issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 joel over 11 years ago

Hi Dinesh, thanks for your reply. I thought it was a data issue at first. My collegue who built the process tells me that data type has never been changed. I also checked they all have values as dateTime, and have tried wrapping the pv! in a todate() expression with the same result. The bit that really confuses me is that if I reduce the cases via a filter it works fine, remove the filter and the same cases break! I also tried networkdays() and this causes the same issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data