Calculation View | Lucanet Knowledge Base

Getting Started

Global Functions

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

Displaying and Editing the Status of Tags

Displaying and Editing Properties of Tags

Validations in XBRL Documents

Creating a Taxonomy Extension

Calculation View

Custom Hierarchies

Using Hidden Elements

Managing Continuation Chains

Working with Footnotes

Adding KVK Filing Information

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

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: