Business rule that runs off sctask and rolls up to RITM and REQ

[oluseyiasol]

I have a requirement  to do the following:
Duration field on the catalog tasks to populate when the catalog task is marked "Closed Imcomplete" or "Closed Complete"

Duration field on RITMs tp populate when all their CTASK's have been closed.

Duration field on requests to populate when all their RITMs have been closed

Any hints on how to complete this requirement without conflicting with OOTB  features.,?

[Tanushree Maiti]

Hi @oluseyiasol 

Refer this post. Script you will get from it.

1. Need help with business duration calculation on a catalog task

  How to get duration for Task created to closed ? 

How to calculate business duration in days 

https://www.servicenow.com/community/itsm-forum/calculating-duration-of-an-sctask-san-diego/m-p/2496...

2. https://www.servicenow.com/community/developer-forum/duration-field-on-ritm/m-p/1886760

3. https://www.servicenow.com/community/servicenow-ai-platform-forum/how-to-get-business-duration-of-ri...