Create calculated field in servicenow

[georgechen]

Hi folks,

Just wondering if anyone can help with a calculated fields in ServiceNow,     In RDBMS system we can create alias fields to achieve this (e.g birthday time = getTime(dob)) , whereas in ServiceNow is there a feature to create a virtual field that is a based on a calculation e.g SLA = 2016-07-14 12:38:09, and SLA Date is 2016-07-14,

A potential solution is to make a Business rule to truncate the date but it will overwrite the field value.

Any advice would be appreciated.

Kind regards,

George

[gyedwab]

If you need to calculate fields in reporting, you can use Explore Analytics -- it doesn't require any javascript, and it can be defined per-report.

For example, if you need to pull a component of the Date-Time field:

Then you can have it in a column in a report like this:

Calculated Column

Or a graphical chart:

Calculated Column (Chart)

And you can do this across tables. The advantage of this approach is that you don't need an admin to set this up for reporting purposes; users can calculate that in-report the way they might in an Excel formula (only automated).