Calculated view show in list view

azabielski · ‎01-19-2017

Is there a way i can show a calculated field value in a list view, i've tried through business rules and the calculated value it self and i am not able to see it once switched to the list view only when i view each individual record.

The use case is when we need to bill someone for an over usage of something i need that last value that needs to be billed a calculated value based on the overage amount and the overage price so that multiple records can be seen/selected at once of all the overage prices and execute a custom ui action on all those rows.

The SN Nerd · ‎01-19-2017

If I am understanding your requirements correctly, the only thing you can do is create a new table that joins the tables together with a pseudo calculated field as shown in my example.

New Table

Field 1: Reference table A

Field 2: Reference table B

Field 3: You field calculated via business logic

Create before update/insert business rule to populate value of field 3.

Dot walk as required to show fields on table A or B in the list.

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

azabielski · ‎01-20-2017

Duh no current.update fixed thank you again this works good i think