View the calculation breakdown in a formula tree

  • Release version: Washingtondc
  • Updated December 12, 2024
  • 1 minute to read
  • View a structured and visual representation of the entire calculation chain.

    Before you begin

    Role required: sn_esg.admin, sn_esg.metric_manager, sn_esg.program_manager, sn_esg.reporting_disclosure_manager

    sn_risk.user (for Risk users).

    About this task

    A formula tree provides transparency by displaying the detailed breakdown of how values are calculated, including all the operands and operations. This is especially helpful for auditing data and debugging.

    Procedure

    1. Navigate to one of the following locations depending on which application you're using.
      • All > Environmental, Social, and Governance > ESG Workspace > Metrics > Calculated metric definitions.
      • All > Risk Management > Risk Workspace > Metrics > Calculated metric definitions.
    2. Open the metric definition for which you want to view formula tree data for and select Calculated Metric Data.
    3. Select the calculated metric data record that you want and then select Show formula tree.
      You can view a visual representation of the entire calculation chain. The formula, associated metric definitions, sub formulas, functions, and so on, are shown.
      Note:
      If you’re seeing an empty page, it's because the formula tree or formula operands are currently empty and are being updated asynchronously. If you’re seeing an error page, it's due to errors in the formula operands that need to be corrected.