Calculation View | Lucanet Knowledge Base

Getting Started

Global Functions

Lucanet Lume

Data Hub

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Introduction to iXBRL

User Interface of the Lucanet XBRL Tagger

All Steps at a Glance

Basic Configuration

Dashboard

XBRL Document

Tagging a Document Manually

Tagging a Document with AI

Working with Layers

Using the Tag Update Preview

Displaying and Editing the Status of Tags

Displaying and Editing Properties of Tags

Validations in XBRL Documents

Creating a Taxonomy Extension

Using XBRL Blueprint

Calculation View

Custom Hierarchies

Using Hidden Elements

Managing Continuation Chains

Working with Footnotes

Adding KVK Filing Information

Using the Document Outline

Generating an iXBRL Report

Displaying Result Documents

Displaying the Preview

Analyzing XBRL Data with Lucanet XBRL Vision

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

XBRL calculation linkbases define mathematical relationships between financial statement elements (e.g. total assets = current assets + non-current assets). These relationships must be correct for the report to pass regulatory validation (e.g. ESEF).

XBRL Tagger provides a dedicated side panel, the calculation view, to:

Display and edit calculations

Display details

Add and remove summands

Identify summands that are also used in other tables and navigate directly to them

Open the calculation view by clicking the icon in the sidebar:

The calculation view is displayed as follows:

The calculation view only contains values after you have selected a cell with a calculated value in a table in the current document.

If the calculation view does not display any values, select a calculated value first.

To edit calculations:

Activate the Edit enabled option.

If necessary, use the drop-down list under Calculated value to change the sign (e.g. whether a summand is added to or subtracted from the total). The following options are available in the drop-down list:

If necessary, change the Weight option. Weight can be set to 1 or -1 and is an additional option to change the sign.

The Weight option is only available when either the element or the total element has the balance type Unknown.

For debit values, Weight is always -1; for credit values it is 1. Because Unknown can be either, you can set the balance type yourself.

In the calculation view, you can activate Full details to display additional technical information for each summand.

Full details help you check that values were parsed correctly and the correct taxonomy elements were applied, for example when taxonomy labels are ambiguous. The following additional information is displayed:

The parsed value read from the source document, without applying

weight

sign logic

The technical name (the XBRL taxonomy element identifier).

In the Calculation linkbase, XBRL Tagger shows which summands are used in other tables of the same report: summands that are used in more than one table are highlighted with a light red background and a red information icon.

Display of a summand that is used in several tables

Click the information icon to navigate directly to the corresponding table and cell. This lets you check cross-table tag relationships at a glance and spot tagging inconsistencies quickly.