Scoring logic for predefined formulas for group factors

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read
  • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Scoring logic for predefined formulas for group factors

    This content explains the predefined formula options available in ServiceNow for calculating scores of group factors within assessments. Group factors consist of multiple manual factors, each contributing qualitative, quantitative, or both types of scores. The scoring logic applies specific formulas to these factor scores, enabling customers to derive comprehensive group factor scores that reflect the combined impact of individual factors.

    Show full answer Show less

    Key Features

    • Predefined Formulas: Users can select from several formulas to calculate group factor scores, including Sum, Minimum, Maximum, Average, Product, and Weighted Average.
    • Factor Contribution Types: Scores are based on manual factors contributing Qualitative, Quantitative, or Both types of data, ensuring flexible scoring based on assessment needs.
    • Qualitative Score Transformation: When enabled, qualitative scores undergo transformation based on defined criteria before final weighting is applied. For example, a calculated qualitative score is multiplied by the group factor’s qualitative weighting to determine the final score.

    How Formulas Work

    • Sum: Adds qualitative or quantitative scores from all relevant manual factors within the group.
    • Minimum: Selects the lowest qualitative or quantitative score among manual factors.
    • Maximum: Selects the highest qualitative or quantitative score among manual factors.
    • Average: Calculates the mean of qualitative or quantitative scores from manual factors.
    • Product: Multiplies qualitative or quantitative scores from manual factors.
    • Weighted Average: Computes the sum of qualitative scores divided by the sum of weights, applicable when qualitative weighting is used.

    Practical Implications for ServiceNow Customers

    By selecting the appropriate predefined formula, customers can tailor the scoring of group factors to align with their assessment methodologies and reporting needs. The ability to handle both qualitative and quantitative data, including transformation and weighting of qualitative scores, allows for nuanced scoring that better represents the assessed criteria. This flexibility supports more accurate risk or performance evaluations and improves decision-making based on assessment results.

    Group factors have multiple predefined formulae and each of them has a specific contribution to the scoring logic.

    Predefined formulae scoring logic

    Users can select one of the following predefined formulae to calculate the scoring for group factors. The scores are contributed by scores of manual factors that comprise a group factor and have factor contribution as Qualitative or Quantitative, or Both.

    The qualitative scores calculated using the predefined formulae are transformed using the transformation criteria if the Transform qualitative score option is selected for the group factor.

    The qualitative scores calculated after transformation will be derived using the Qualitative weighting of the group factor. For example, if the calculated score is 10 and the Qualitative weighting is 50%, then the final score for group factor will be calculated as 10 x 0.5 = 5.

    Sum

    For Qualitative, this formula adds up the qualitative scores in an assessment instance. The scores are contributed by scores of manual factors that comprise a group factor and have factor contribution as either Quantitative or Both.

    For Quantitative, this formula adds up the quantitative scores in an assessment instance. The scores are contributed by scores of manual factors that comprise a group factor and have factor contribution as either Quantitative or Both.

    Minimum

    For Qualitative, this formula takes the minimum of qualitative scores in an assessment instance. The scores are contributed by scores of manual factors that comprise a group factor and have factor contribution as either Quantitative or Both.

    For Quantitative, this formula takes the minimum of quantitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Quantitative or Both.

    Maximum

    For Qualitative, this formula takes the maximum of qualitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Qualitative or Both.

    For Quantitative, this formula takes the maximum of quantitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Quantitative or Both.

    Average

    For Qualitative, this formula takes the average of qualitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Qualitative or Both.

    For Quantitative, this formula takes the average of quantitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Quantitative or Both.

    Product

    For Qualitative, this formula multiplies qualitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Qualitative or Both.

    For Quantitative, this formula multiplies quantitative scores in an assessment instance. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Quantitative or Both.

    Weighted average

    For Qualitative, this formula divides the sum of qualitative scores in an assessment instance by the sum of weights. The scores are contributed by scores corresponding to the factors that a comprise a group factor and have factor contribution of either Qualitative or Both.