Calculated Value

Vikram Meena
Giga Contributor

Hi,

What is the use of calculated value that is present in Dictionary Entry,Please tell me with some script 

Thanks in advance  

 

1 ACCEPTED SOLUTION

Simple algebric calculation is one of the parameters while choosing between BR and Function Fields. The function field will execute and calculate value but it doesn't store that value in the database so it means there is no history to be maintained. Its just a display value calculated and displayed every time a form/list loads. 

On the other hand, Business rule calculates and stores the value into the database which means we would have a history of value changes and better performance as it doesn't calculate value unnecessary rather on when values updated only. 

Take a look at Function Fields limitation section of the doc that has some good points that will help choose between function field and other alternatives. 

Regards,
Muhammad

View solution in original post

7 REPLIES 7

You should also have a look at below link to understand Function field and its differences as compare to other script options available i.e Calculated fields, business rules etc.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/build/platform-functions/con...

I hope that helps!

 

Regards,
Muhammad

Means that whenever i want to perform any mathematical operation within a Form or table i should use Function Field instead of Business Rule .

Am i Right ?

Simple algebric calculation is one of the parameters while choosing between BR and Function Fields. The function field will execute and calculate value but it doesn't store that value in the database so it means there is no history to be maintained. Its just a display value calculated and displayed every time a form/list loads. 

On the other hand, Business rule calculates and stores the value into the database which means we would have a history of value changes and better performance as it doesn't calculate value unnecessary rather on when values updated only. 

Take a look at Function Fields limitation section of the doc that has some good points that will help choose between function field and other alternatives. 

Regards,
Muhammad