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
6 replies
Subscribers
8 subscribers
Views
3909 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi, I need to calculate a SLA end date based on a SLA start date, the numbe
moritzw
over 10 years ago
Hi,
I need to calculate a SLA end date based on a SLA start date, the number of days the SLA lasts and N x intervals in which the SLA was interrupted. I came up with something like this so far:
=if(isnull(ri!slaStartTime_dt),null,workday(ri!slaStartTime_dt,ri!slaInDays_int,{date(2014,12,25),date(2014,12,26)})) + {interval1,interval2}
However I don't know how to get the sum of multiple intervals at the end. How could I do this?
TIA, Moritz
...
OriginalPostID-126149
OriginalPostID-126149
Discussion posts and replies are publicly visible
Parents
0
moritzw
over 10 years ago
found a solution. Thanks!
=if(isnull(ri!slaStartTime_dt),null,workday(ri!slaStartTime_dt,ri!slaInDays_int + rule!GetNetworkDaysForSlaInterrupts(ri!slaInterruptStartTimes_dt,ri!slaInterruptEndTimes_dt),{date(2014,12,25),date(2014,12,26)}))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
moritzw
over 10 years ago
found a solution. Thanks!
=if(isnull(ri!slaStartTime_dt),null,workday(ri!slaStartTime_dt,ri!slaInDays_int + rule!GetNetworkDaysForSlaInterrupts(ri!slaInterruptStartTimes_dt,ri!slaInterruptEndTimes_dt),{date(2014,12,25),date(2014,12,26)}))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data