Calculation Issue - Risk Assessment

Calculation Issue - Risk Assessment

Purpose Statement

This article provides step-by-step instructions for resolving "Failed Calculation" warnings that occur when performing Risk Assessments. The calculation failures typically result from missing score values in Field Management configurations, which prevent the system from properly calculating risk scores and needed fire flow values.


Background Information

Risk Assessment calculations in the Fire Prevention module depend on properly configured field values with associated scores. When a field lacks a score value or Construction Types are improperly formatted, the system cannot complete the risk calculation, resulting in a "Failed Calculation" warning. This issue commonly occurs when custom field values are added without corresponding scores, or when Construction Type formatting doesn't meet the system requirements for fire flow calculations.

The system requires all risk assessment fields to have numerical scores to generate accurate risk ratings and compliance reports. Resolving these calculation issues ensures data integrity and maintains the accuracy of your department's risk assessment program.


Required Permissions

To resolve Risk Assessment calculation issues, the following permission is required:

  • Fire Prevention bucket - Risk Assessment Edit Score
Calculate Needed Fire Flow - Reference the attached document to this KBA for Construction Type formatting information.


Video




Step-by-Step Guide

Warning
To resolve a Calculation Issue for Risk Management this permission is needed: Fire Prevention bucket - Risk Assessment Edit Score






This error message could be encountered when performing a Risk Assessment:






Problem: A field in Field Management has no associated score value:




Alert
NOTE: Construction Types have to be formatted correctly to calculate the needed fire flow.  Reference the attached document in the related KBA in reference to formatting the Construction Type in Admin > Field Management > Construction Type


Resolution:

Option #1 (preferred choice):

1.  Using an an Ad Hoc report, find all instances of the Calculation Issue and change the field to a System Created value.
2. Access all records with the drop down list item and change to an item that has an valid  associated score.
3. Navigate to Admin > Field Management > Field with error and delete the List Item that has no score.


Example Ad Hoc Report Screenshots with necessary information:

  1. Data source is Occupancies using a tabular report with columns for the identifying information for the occupancies and the field that is causing the Calculation Issue error:



  1. Criteria for the report example:



  1. Report results:




Select Occupancy Id and update the field causing the error.


Option #2:

1. Using Admin > Field Management, select Edit for the field with the Calculation Issue and enter a score:


 


Warning
NOTE: Use care to enter a reasonable value to maintain integrity with the scoring system values.


Best Practices

Do:

  • Use Option 1 (Ad Hoc Report method) when multiple records are affected
  • Verify Construction Type formatting before troubleshooting calculation issues
  • Document score values and their rationale for future reference
  • Test calculations after making changes to ensure proper functionality
  • Review all related occupancies when updating field values

Don't:

  • Assign arbitrary score values without considering their impact on risk ratings
  • Delete field values that are actively used in occupancy records
  • Make bulk changes without first identifying all affected records
  • Skip the verification step after resolving calculation issues


Troubleshooting & FAQs

Q: The calculation issue persists after following these steps. What should I check? A: Verify that Construction Types are properly formatted according to the "Calculate Needed Fire Flow" reference document. Improper formatting is a common cause of persistent calculation errors.

Q: How do I determine what score value to assign to a missing field item? A: Review your department's risk assessment methodology and assign scores that align with the relative risk level of the field value. Consult with your Fire Prevention staff for guidance on appropriate scoring.

Q: Can I prevent future calculation issues? A: Yes, always assign score values when creating new field management items, and regularly audit your field configurations to ensure all items have associated scores.

Q: Will changing scores affect historical risk assessments? A: Yes, score changes will impact any recalculations of existing assessments. Document changes and consider the implications for compliance reporting.




    • Related Articles

    • Risk Assessment - OVAP Scoring

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to calculate the Risk Assessment Score for an Occupancy. Background OVAP Definition: Occupancy Vulnerability Assessment Profile Purpose: Risk assessment (AKA OVAP Scoring) is a ...
    • Risk Assessment - OVAP Scoring

      Purpose Statement The purpose of this feature is to calculate the Risk Assessment Score (OVAP Score) for occupancies to identify and evaluate important factors and characteristics that determine their relative risk to a community. This scoring system ...
    • Calculation Issue - Risk Assessment

      Purpose The purpose of this Knowledge Base Article is to provide instructions on how to resolve a "Failed Calculation" warning performing a Risk Assessment. Related Article Calculate Needed Fire Flow - Reference the attached document to this KBA for ...
    • Admin > Field Management

      Purpose Statement Field Management enables administrators to configure and customize form fields across the First Due platform. This feature allows agencies to tailor data collection fields, set user permissions, and manage dropdown lists to meet ...
    • Occupancy Log

      Purpose Statement The Occupancy Log allows inspectors to record visits, complaints, and phone conversations that aren't tied to formal inspections but are crucial for understanding the full occupancy history. This feature provides a comprehensive ...