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
1876 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
dbabu
over 11 years ago
Is your PV named date? And has the type of the PV changed at any point, i.e. say initially from date/time to more recently to be date? I am thinking maybe some instance has an incorrect value for this PV and it might be only for specific rows that this function is throwing the error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
dbabu
over 11 years ago
Is your PV named date? And has the type of the PV changed at any point, i.e. say initially from date/time to more recently to be date? I am thinking maybe some instance has an incorrect value for this PV and it might be only for specific rows that this function is throwing the error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data