CSA · Question #378
Which fields can be configured in reporting to perform arithmetic, coalesce, concatenation, and length?
The correct answer is B. Function fields. Function fields in ServiceNow reporting allow for configuration to perform various operations like arithmetic, coalesce, concatenation, and length on existing data fields.
Question
Which fields can be configured in reporting to perform arithmetic, coalesce, concatenation, and length?
Options
- ASourcing fields
- BFunction fields
- CComputational fields
- DCalculation fields
How the community answered
(20 responses)- A5% (1)
- B95% (19)
Why each option
Function fields in ServiceNow reporting allow for configuration to perform various operations like arithmetic, coalesce, concatenation, and length on existing data fields.
'Sourcing fields' refers to the original database fields from which report data is drawn, not a type of field that performs calculations itself.
Function fields enable users to create virtual fields within reports by applying database functions such as arithmetic operations, coalesce (handling nulls), string concatenation, and calculating string length to existing fields, enhancing reporting capabilities without altering the database.
'Computational fields' is not the standard or official terminology used in ServiceNow for fields with these specific data manipulation capabilities.
'Calculation fields' is not the standard or official terminology used in ServiceNow; 'Function fields' is the correct term for this reporting feature.
Concept tested: ServiceNow reporting Function Fields
Source: https://docs.servicenow.com/bundle/utah-platform-user-interface/page/use/reporting/concept/function-fields.html
Topics
Community Discussion
No community discussion yet for this question.