I want to add column to display results of calculations with other fields in the list.

jimin han
Kilo Contributor

Hi, I want to add column to display results(it is like pass or none-pass of standard) of calculations with other fields in the list

I don't want to save those results, I just want to display it when I check a list.

How can I do that?

1 ACCEPTED SOLUTION

John Dahl
Tera Guru

You can create a Calculated Value field that will not save the data. A downside is that you also cannot report on the value. If that is still ok, then look at this post:

https://community.servicenow.com/community?id=community_question&sys_id=3a648b69dbd8dbc01dcaf3231f961976

 

 

View solution in original post

3 REPLIES 3

John Dahl
Tera Guru

You can create a Calculated Value field that will not save the data. A downside is that you also cannot report on the value. If that is still ok, then look at this post:

https://community.servicenow.com/community?id=community_question&sys_id=3a648b69dbd8dbc01dcaf3231f961976

 

 

Thank you for answering my questions.

But, I want to apply to my database view

And, I want to add those fields(not saved) displaying existing fields , not changing my field 

In my cases, how can I do that?

 

If you need the values in a database view, then you need to make it a field on one of the tables.

In my previous response, I should have said "Function" field rather than a Calculated field. Calculated fields are defined on the table and stored in the database, but there are still limitations. A Function field does real-time calculations without saving to the database, but they are not available in database views.