Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
1878 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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...
OriginalPostID-45276
Discussion posts and replies are publicly visible
Parents
0
joel
over 11 years ago
Yep, thanks! Swapped the date to pp!starttime and that worked, so it could be a data issue. Strange thing is in another column that variable calculates no problem when not using the calworkdays or networkdays functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
joel
over 11 years ago
Yep, thanks! Swapped the date to pp!starttime and that worked, so it could be a data issue. Strange thing is in another column that variable calculates no problem when not using the calworkdays or networkdays functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data