Controlling Accuracy of Cells

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Creating a New Report >

Controlling Accuracy of Cells

The accuracy of monetary and other numeric values in the XBRL report can be controlled by setting the following report properties:

 

1.Accuracy of monetary cells
2.Accuracy of numeric cells
3.Accuracy of percentage cells

 

These properties are available in the Solvency II Report Pane, in the Properties group.

inc-xa-slv-accuracy1

The property Accuracy of Monetary Cells applies to numeric cells in the report that represent a monetary value.

 

The property Accuracy of Numeric Cells applies to numeric values that have no unit (excluding percentage values, which have their own data type).

 

The property Accuracy of Percentage Cells applies to values that represent a percentage.

 

To view the type of a cell, first select a cell, and then click the Cell tab in the Solvency II Report Pane and observe the Type property, for example:

inc-xa-slv-accuracy2

The accuracy you select from the Solvency II Report Pane controls the accuracy that will be written for this fact in the XBRL instance file. More specifically, the "Accuracy" properties are bound to the decimals attribute in the XBRL instance file. For example, in the image below, the accuracy value indicated in the brackets corresponds to the value of the decimals attribute in the XBRL instance file.

inc-xa-slv-accuracy3

By default, accuracy is set as follows:

 

The Accuracy of Monetary Cells is set to Cents (2), which sets the value of the decimals attribute in the XBRL instance to "2"
The Accuracy of Percentage Cells is set to Basis Points (4), which sets the value of the decimals attribute in the XBRL instance to "4".
The Accuracy of Numeric Cells is set to Exact (INF), which sets the value of the decimals attribute in the XBRL instance to "INF".

 

You can set the accuracy-related properties at report, table, or cell level (see the corresponding tabs in the image above). If you set accuracy at multiple levels, keep in mind that the more specific property always overrides the more generic one. For example, the accuracy set at cell level takes priority over the one set at table level. Likewise, the accuracy set at table level takes priority over the one set at report level.

 

For monetary and numeric cells, the accuracy value can be either positive or negative.

 

A positive value N specifies the accuracy of up to N digits to the right of the decimal place. For example, the value 2 specifies the accuracy to be in cents, while the value 3 specifies the accuracy to be up to mills.

 

A negative value N specifies the accuracy of up to N digits to the left of the decimal place. For example, the value -3 specifies the accuracy to be up to thousands, while the value -6 specifies the accuracy to be up to millions.


© 2019 Altova GmbH