Calculated view show in list view

[azabielski]

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]

To fulfill your requirement you would need to create a custom UI page or convert your field to non calculated and move the logic to a business rule.

[azabielski]

I tried the business rule way however, i didnt have any scuess at all unless i set the rule to display , but then it doesnt show in the list view and i cant process it to a bill.

Any help in that area would be great.

[The SN Nerd]

You have to

1. Turn 'Calculated Field' off
2. Copy logic into a before update/insert business rule
3. Run a once off script on all in flight tickets to populate the field

[azabielski]

Right so just for new records the issue is its actually 2 tables that are need to create the value. I did this previously with a tablar function in sql but i need to replicate this in Service Now. So i currently have both tables in a database view.