Which fields can be configured in reporting to perform arithmetic, coalesce, concatenation,and lengt

HarshithaNaidu
Tera Contributor

Which fields can be configured in reporting to perform arithmetic, coalesce, concatenation, and length?

A.Sourcing fields

B.Function fields

C.Computational fields

D.Calculation fields

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @HarshithaNaidu 

 

Functional Field

 

AGLearnNGrow_0-1741465429140.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

3 REPLIES 3

vramamurthi
Tera Contributor

Answer is B. Function fields.

 

Please let me know if it is correct.

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @HarshithaNaidu 

 

Functional Field

 

AGLearnNGrow_0-1741465429140.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Shivalika
Mega Sage

Hello @HarshithaNaidu 

 

The answer is (B) Function fields 

 

Explanation:

In ServiceNow reporting, Function Fields allow you to manipulate data using various operations such as:

 

Arithmetic operations (addition, subtraction, multiplication, division)

Coalesce (merging values)

Concatenation (joining strings together)

Length (calculating the number of characters in a string)

These fields help modify data dynamically within a report without altering the actual database records.

 

Please mark my answer as solution and helpful if it helped you in anyway 

 

Regards, 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE

ISQCY