Calculated Column/Field in report

[Sana18]

Hi

I am new to Servicenow and creating a report where I have to create two calculated columns:

1. Last Compliance Date + 1 Year to get next compliance date

2. Number of days to this next compliance date

Is it possible to define these columns anywhere like you do in any other reporting/analytics tool (Power BI or Tableau).

Also, what access do I need in order to do so.

Any help is much appreciated.

Regards,

Sana

[Sana18]

Thanks, Sachin.

[sachin_namjoshi]

please mark my answer as correct if your query is resolved.

Regards,

Sachin

[Dean4]

Hi,

In Quebec, ServiceNow has added 'function fields' which allows you to create calculated values in reporting.

Function field | ServiceNow Docs

Creator Toolbox - Report Calculations - YouTube

Regards,

Dean.

[Sebas Di Loreto]

I think Dean4 is right. I experimented with these fields some time in the past and you might be able to do it.

This link specifically talks about "report on function fields": https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/reporting/concept/function-fie...

[Eric Levinson]

Looks like "report on function fields"  is an admin function.  is there any other way a non admin can add a calculated field to the report?  It's not rocket science - I just need somewhere to add the column to the report (not the table) and put the formula in.