ServiceNow Certified Application Specialist – Performance Analytics — Question 78

The formula for % of incidents resolved by first assigned group is configured as follows:

([[ Number of resolved incidents by first assigned group ]] / [[ Number of resolved incidents ]]) * 100

You observe “No Score” whenever the value of Number of resolved incidents component indicator is 0.

What can be done to enhance the formula so it returns 0 instead of “No Score” when there are no resolved incidents?

Answer options

• A. Add a conditional JavaScript statement in the formula to return 0 if the value of Number of Resolved Incidents is 0.
• B. Enable the property “Allow formula component to be NULL”.
• C. Set the property “Value when nil” to 0.
• D. Enable the property “Render continuous lines”.

Correct answer: A

Explanation

The correct answer is A because adding a conditional JavaScript statement allows the formula to specifically handle the case when there are zero incidents by returning 0 instead of 'No Score'. The other options do not directly address the issue of returning a value when the denominator is zero, making them ineffective for this scenario.