Expected Values
For a properly generated instance in CDM, form cells must be formatted according to the type of data that is entered.
To avoid errors, follow these tips:
- Monetary data points are formatted as Currency and/or Numeric.
- Integer data points are formatted as Numeric with no decimal places.
- Format as percentage the Excel cells in forms before you enter values or data.
- Boolean data points receive one of these possible values: true, false, 0, or 1.
- QName type cells accept as values the appropriate
MemberXBRLCodefor values that are reported. The user must insert the value for QName. They should be formatted as General or Text. - String data points are formatted as General or Text.
For a percentage:
Cell value |
Cell format |
Reported fact |
Reported formatted fact |
|---|---|---|---|
12.34 |
Percentage |
0.1234 |
12.34% |
1234 |
Numeric or General or Currency |
12.34 |
1234% |
For QName:
QName type cells must be populated by the user by referencing the MemberXBRLCode of data points. To identify the correct values, refer to additional information in the COREP FINREP technical notes.