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

...

Discussion posts and replies are publicly visible

Parents

0 moritzw over 10 years ago

got this working using the reduce() looping function.

However, I also need to make sure that only working days are included in the calculation.

So if I interrupt the SLA from Friday to Monday, the SLA End Date would be two additional working days in the future. Not quite sure how to achieve this at the moment.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 moritzw over 10 years ago

got this working using the reduce() looping function.

However, I also need to make sure that only working days are included in the calculation.

So if I interrupt the SLA from Friday to Monday, the SLA End Date would be two additional working days in the future. Not quite sure how to achieve this at the moment.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data