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
3470 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
marks
over 10 years ago
Great--I wasn't sure if I could use a null in a number-formatted field. Thanks again!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
marks
over 10 years ago
Great--I wasn't sure if I could use a null in a number-formatted field. Thanks again!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data