Resources
Help & Support ↗ Lucanet Learning Space ↗
Documentation
Getting Started
Global Functions
Lucanet Lume
Administration
Data Hub
Consolidation & Financial Planning
Lease Accounting
Extended Planning & Analysis (xP&A)
ESG Reporting
User Roles and User Interface in ESG Reporting
General Functions in ESG Reporting
All Steps at a Glance – ESG Reporting
Creating Report
Working with Duplicated ESG Reports
Mapping Double Materiality Assessment Results
Configuring the Report Questionnaire
Structure of the Report Questionnaire
Using the Questionnaire Builder
Adding Custom Questions
Adding Formula-Based KPIs
Starting Data Collection
Collecting Data for ESG Report
Checking Data
Generating ESG Report
Exporting Data
Creating Custom Emission Factors
Reopening an ESG Report
Canceling an ESG Report
Disclosure Management
XBRL Tagger
Tax Compliance & Reporting
Banking & Cash Management
Data Collection
Glossary

Adding Formula-Based KPIs in Lucanet ESG Reporting

Overview

As an ESG Administrator in Lucanet ESG Reporting, you can add formula-based KPIs to the ESRS, ESRS 2.0, or VSME questionnaire. A formula-based KPI is a calculated value: instead of being answered by an ESG Data Collector, it is calculated from the answers to other questions in the same questionnaire.

This keeps derived metrics, for example ratios, shares, or totals, in the Lucanet CFO Solution Platform, and the derivation is transparent for everyone who works with the report. A manual calculation after data collection is no longer needed.

You add formula-based KPIs in the Questionnaire builder, in the same place as custom questions, that is, in the disclosure requirement they belong to.

As an ESG Administrator, you can only add formula-based KPIs while the questionnaire is editable, that is, while you are working on a draft (see Using the Questionnaire Builder).

Formula Elements in Lucanet ESG Reporting

A formula in Lucanet ESG Reporting combines operands with operators.

Operands

An operand is a value from the questionnaire that is used in the formula calculation. Lucanet ESG Reporting provides an operand catalog with all operands that produce a number in the questionnaire:

OperandDescription
Numeric and monetary questionsThe answer to a question of the type Numeric input or Monetary.
Static table cellsA single cell of a static table, identified by its row and column. A table question therefore provides as many operands as it has cells.
Dynamic table column totalsThe total of a dynamic table column across all rows the ESG Data Collector enters.
Other formula-based KPIsA KPI that is already defined in the same questionnaire.
Fixed numbersA number entered directly in the formula, for example for a conversion or constant factor.

Questions that do not produce a number, that is, Text input, Yes/No, and Date, are not offered in the catalog and cannot be used in a formula.

Operators

The formula editor in Lucanet ESG Reporting provides a toolbar with the following operators:

OperatorMeaning
+Addition
−Subtraction
×Multiplication
÷Division
%Expresses the result as a percentage
( and )Parentheses, to control the order of calculation

You never type formula syntax yourself. Each operand is inserted as a separate element that you can remove individually, and it keeps pointing at the right question even if that question is later renamed.

Adding a Formula-Based KPI in Lucanet ESG Reporting

To add a formula-based KPI in Lucanet ESG Reporting:

1

In the Questionnaire builder, click Edit to start a draft.

2

Expand the questionnaire down to the disclosure requirement to which you want to add the KPI.

3

On the disclosure requirement, click + Add custom question.

Shows the questionnaire builder in Lucanet ESG Reporting. Highlighted in red is '+ Add custom question' on the 'BP-1 General basis for preparation of sustainability statements' disclosure requirement.
'+ Add custom question' button on a disclosure requirement
4

In the Add custom question dialog, choose the Formula-based KPI option in the Custom information section and click Next. The dialog is then displayed as follows:

Shows the 'Add custom field: Formula-based KPI' dialog in Lucanet ESG Reporting with 'KPI number', 'KPI name', 'Unit', 'Decimal places' set to 2, and an empty 'KPI / Calculated field' formula editor.
Entering the details of a formula-based KPI
5

Enter the KPI details:

  • KPI number: The number under which the KPI appears in the questionnaire, for example BP-1.99.
  • KPI name: The name displayed to the ESG Data Collectors.
  • Unit: The unit of the calculated value, for example tCO2e, MWh, FTE, or %.
  • Decimal places: Choose 0 or 2 from the drop-down list. The default is 2.
6

In the KPI / Calculated field area, build the formula. You have the following options:

  • Insert operands: Click @ or type @ in the formula field. The operand catalog opens and displays the structure of the questionnaire. Use the search to find an operand by its question number or its text. Click the operand you want to use to insert it into the formula.
  • Insert operators: In the toolbar, click the operator you want to use.
Shows the operand catalog in Lucanet ESG Reporting with 'independent board' in the search field and matching questionnaire entries. Highlighted in red are the catalog and the '@' button used to open it.
Searching for an operand in the operand catalog

Repeat until the formula is complete. To remove an operand, click the x next to it.

Shows the 'Add custom field: Formula-based KPI' dialog in Lucanet ESG Reporting with 'KPI number' set to 'BP-1.99', 'KPI name' set to 'Share of independent board members', 'Unit' set to '%', and two operands combined with division and percentage operators.
A completed formula for a percentage KPI
7

Click Add.

When you add a formula-based KPI, the following applies:

  • The KPI is inserted at the top within the disclosure requirement and is marked with a formula icon.
  • The KPI has no reporting entity assignment of its own. A KPI is displayed to a reporting entity only if that reporting entity is assigned to all the questions used in its formula (see Using the Questionnaire Builder).
  • If the parent disclosure requirement is hidden, the KPI is hidden as well.
Shows the questionnaire builder in Lucanet ESG Reporting. Highlighted in red is 'BP-1.99 Share of independent board members' with its formula icon and 'KPI' badge under the BP-1 disclosure requirement.
A formula-based KPI in the questionnaire builder

Like custom questions, formula-based KPIs are part of the questionnaire draft. Click Apply changes to save them, or Discard to remove all changes made in the draft.

Checking a KPI Before Data Collection in Lucanet ESG Reporting

To see how a KPI in Lucanet ESG Reporting will appear to the ESG Data Collectors, click the three-dot icon next to it and choose Preview. The preview displays the KPI number, the KPI name, the formula in full, and the read-only value field with its unit.

Shows the 'Preview' dialog in Lucanet ESG Reporting for 'BP-1.99 Share of independent board members', with the full operand paths, a division and percentage formula, and a read-only value field with '%'.
Preview of a formula-based KPI

In the formula, each operand is displayed with its complete path — question number, question text, and, for table cells, the row and column — so you can check that the formula refers to the values you intended.

Editing and Deleting a Formula-Based KPI in Lucanet ESG Reporting

In Lucanet ESG Reporting, using the three-dot icon next to the KPI, you can edit or delete the KPI in the same way as a custom question. When you edit a KPI, you change both its details and its formula.

Displaying the Formula-Based KPI During Data Collection in Lucanet ESG Reporting

Once data collection has started in Lucanet ESG Reporting, the KPI is calculated from the answers of each reporting entity and is displayed as read-only — see Filling Out Report Questionnaire. In the aggregated report, a group value is calculated in addition to the per-entity values — see Generating ESG Report.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.

Page IDKB5616660

Last updated on Oct 27, 2026

Table of Contents
OverviewFormula Elements in Lucanet ESG ReportingAdding a Formula-Based KPI in Lucanet ESG ReportingChecking a KPI Before Data Collection in Lucanet ESG ReportingEditing and Deleting a Formula-Based KPI in Lucanet ESG ReportingDisplaying the Formula-Based KPI During Data Collection in Lucanet ESG Reporting
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG