Calculated Column/Field in report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-18-2020 08:24 AM
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
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-18-2020 08:54 AM
You will need to create custom columns and configure business rule to update values in these columns based on your requirements.
Check Create Columns for steps to create column.
I will recommended to complete NOW learning courses.
https://developer.servicenow.com/dev.do#!/learn/learning-plans/paris/new_to_servicenow
Regards,
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā10-28-2022 11:25 AM - edited ā10-28-2022 11:25 AM
Hi Sachin! While I'm an expert in SQL report development, which is an unlimited technology, I'm still learning a lot about SNOW's basic limited reporting platform. I'm having the same issue - I need to add a calculated column - however when I create a report or attempt to modify a report I can't find where I can create and add the calculated column. In my use case - my report shows an incident backlog by Classification and Module. However sometimes the module name is empty. I want the calculated system to be "Classification" field unless the Module field is populated,, then it needs to be Module instead.
Is "create calculated column" in the report tool an extended or admin function? We have a few admins in SNOW, the rest are users and don't have access to any advanced reporting utilities. We would need to create a ticket to request what we want.
I checked your link and it looks like it was redirected to an ITIL page. I'm trying to find the documentation on how to create a calculated column in SNOW online help but not having any luck finding this in the Reporting tool. It seems I need to add the calculated column to the physical Incident table first?
Any help would be greatly appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-18-2020 09:26 AM
Thanks for your response, Sachin.
Is there any other way to create dynamic columns without actually creating them in the table while writing a report?
Thanks again,
Sana

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-18-2020 09:59 AM
You can't create columns only in report like reporting tools.
Regards,
Sachin