Custom calculated Incident field

[WayneHadley]

Greetings,

We have an internal customer who is currently using an Excel spreadsheet (please see attached) as a means to calculate a "custom" SLA. With reference to the spreadsheet column = Total Outage is already an Incident Table field. Columns for Total Minutes and Current SLA don't have corresponding Incident Table fields, these are calculated manually in the spreadsheet.  The formula for Total Minutes includes number of days which means the number of days in the current month at that point in time. 

My questions: is it possible to create incident calculated fields for Total Minutes and Current SLA to replicate the formulas in the spreadsheet? If so, how can this be accomplished?

Thanks in advance for your feedback.

[Ankur Bawiskar]

@WayneHadley 

yes you can use calculated fields on incident table and then add the calculation there similar to the formulas applies in Escel

If my response helped please mark it correct and close the thread so that it benefits future readers.

[WayneHadley]

It looks like this thread may provide the method for a calculated field? https://www.servicenow.com/community/platform-analytics-forum/script-for-minutes-in-each-month/m-p/1...

[Ankur Bawiskar]

@WayneHadley 

yes it should

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[TheJoeDC]

Couldn't you capture this directly from the Incident SLA table? Use Business Duration for total minutes and achieved/breached for the current SLA?