Good Morning Team,
I am up against a problem I don't know how to solve and am hoping somebody has some insight into it for me.
We have a catalog item with a field called "Go live date" and it represents when a client we are setting up will "Go live" with our company.
Internally the manager of a team wants an SLA to be created that is three weeks prior to the go live date which we did with no issues BUT they want the SLA breach time to be changed to three weeks prior if the go live date changes.
Example: Go live is 5/1/2022 setting the SLA to 4/10/2022 but if the go live is changed to 5/8/2022 then the SLA should recalculate to 4/17/2022.
I can always look at the SLA table and match it with the task then change the breach time manually BUT how should I handle actual and business elapsed time and percentages since they won't be accurate any longer? It seems like I would have to re-calculate both manually which seems to be an impossible task to me.
