how to create calculated field that shows how long it took for a RITM to be closed

[Atheher Fathima]

I have a requirement to create a calculated field that shows how long it took for a RITM to be closed

RITM Closed - RITM Open = Duration.

How can this be achieved. any help on this is greatly appreciated.

[Mike_R · Accepted solution]

You can create a function field in your report

[Atheher Fathima]

Thank you Mike! does this have to be done on each report? or there is a way to use it in all reports under this table?

[Mike_R]

Once you create, it will be available for all reports.

[ronprice]

After you add the Duration field on the RITM, set up a business rule like the below:

Please mark as correct/helpful if this answered your question.