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
10 replies
Subscribers
7 subscribers
Views
3467 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I'm tracking the number of days between two process events using the calwork
marks
over 10 years ago
I'm tracking the number of days between two process events using the calworkdays function, but I''m not getting back any results. The formula checks to see if there was a approval in the process, and then runs the calworkdays function based on that:
=if(pv!pvSupervisorApproval="Approve",(calworkdays(pv!pvSrq_Approved_DateTime,pv!pvSrq_Completed_DateTime)),(calworkdays(pv!pvSrqSubmitted_datetime,pv!pvSrq_Completed_DateTime)))
I've confirmed that all the datestamp fields are "date and time" format, and I can display all the fields above in a report without issue, so I know the data is there. I already have the "Completed" filter in place, so I know the processes are complete. The expression above is set to a "number" format, although I've also tried "Normal text"--either way, I get nothing listed in the result. I've done similar expressions using the if function and the appoval field without issue. If I just run the following:
=calwork...
OriginalPostID-76492
OriginalPostID-76492
Discussion posts and replies are publicly visible
Parents
0
shelzle
over 10 years ago
From my experience missing PVs or PVs with a "null" value do have impact. Could you try something like this
=if(or(isnull(pv!pvSrqSubmitted_datetime), isnull(pv!pvSrq_Completed_DateTime)), 0, calworkdays(pv!pvSrqSubmitted_datetime,pv!pvSrq_Completed_DateTime))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
shelzle
over 10 years ago
From my experience missing PVs or PVs with a "null" value do have impact. Could you try something like this
=if(or(isnull(pv!pvSrqSubmitted_datetime), isnull(pv!pvSrq_Completed_DateTime)), 0, calworkdays(pv!pvSrqSubmitted_datetime,pv!pvSrq_Completed_DateTime))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data