function field in report servicenow

[hind]

Hi everybody

I am trying to create a report which displays the average processing time of RITM I created a calculate field of type formula and I put: Formula: glidefunction:datediff(closed_at, sys_created_on) here is the error which gives me

[Ravi Chandra_K]

Hello @hind,

The script you have written wouldn't work the way it is 

Pls refer the below thread:

https://www.servicenow.com/community/developer-forum/script-a-function-field-to-get-duration-from-no...

Please mark the answer as helpful and correct if helped.

Kind Regards,

Ravi 

[Voona Rohila]

Hi @hind 

Remove 'Formula:' and try

Just use glidefunction:datediff(closed_at, sys_created_on)

Refer Syntax here : https://docs.servicenow.com/bundle/xanadu-platform-administration/page/build/platform-functions/conc...