To calculate the open days of a major problem from opened_at to today, need report that shows count

[HarshaVardhanB]

There is requirement of creating a report of number of days the problem is opened, based on the opened/created date to today for a major problem record, without modifying/creating a field column on Problem table 

[Dr Atul G- LNG]

Hi @HarshaVardhanB 

https://www.servicenow.com/community/developer-articles/function-fields-in-servicenow-reports-calcul...

CC:

@AnveshKumar M 

[Ankur Bawiskar]

@HarshaVardhanB 

you can use function field for this in reporting.

Function field is not an actual column but helps creating a virtual column which can display data

check this video and it explains the details

Reporting Function fields - Platform Analytics Academy - April 5th, 2023 

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

[Ankur Bawiskar]

@HarshaVardhanB 

Hope you are doing good.

Did my reply answer your question?

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

[Bhuvan]

@HarshaVardhanB 

Use function fields in report designer to calculate number of days problem record was opened. This will not create any fields or store the data in database and optimal for creating reports.

See below for sample how to use function fields in reports,

https://www.servicenow.com/community/developer-articles/function-fields-in-servicenow-reports-calcul...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan