<< Click to display table of contents >>
Figure 24: Datafield settings
Path: <datacolumn><datafield> Contains the data field settings of the data column. Note! If extra fields are used on a drill-down sheet, do not define this element for the actual data columns. Otherwise drill-down data will not be shown correctly. For the comment column, this element can be defined. Attributes datasource: Defines the type of the column. Possible values •report •input •celldrilldown •tr type: Defines the type of data in the column. Possible values: •numeric: The column contains numeric data. •extra: The column contains extra field data. •formulas: The column contains a formula. •comment: The column is used for comments. •trlink: The column is used in transparent reporting. •invdata: The column contains inventory data. presentationtype: Defines how the data in the column is displayed on the template. The 'type' attribute defines how the data is saved. Possible values: •formulas Example: <datafield presentationtype="formulas" type="numeric" datasource="input"> <numeric amount="unit" period="periodical"/> </datafield> In this example, the formula comes from the Excel sheet and its result is saved as a unit periodical figure. |
Path: <datacolumn><datafield><invdata> Defines the settings for a column that contains inventory data (<datafield type="invdata">). Attributes field: Defines the type of the field. Possible values: •amount: The column is used for entering the inventory value sum. •margin: The column is used for entering the margin percent for the periods. •taxpcent0: The column is used for entering the tax percent for period 0. •taxpcent: The column is used for entering the tax percent used for other periods. |
Path: <datacolumn><datafield><extra> Defines the code of the extra field (the DATAEXDEF_UDID value from the FMDATAEXDEF[TT] table). Used if <datafield type=”extra”>. Attributes field: Defines the extra field udid in the database. |
Path: <datacolumn><datafield><formulas> Contains the definitions of formulas in the data column. |
Path: <datacolumn><datafield><formulas><formula> Defines the formula for saving data. Note that in formulas defined in the XML file, the separator must be comma (not semicolon). Attributes type Possible values: •all Example: AVERAGE([datacolumn_1]:[datacolumn_3],[datacolumn_6]:[datacolumn_8]) IF(([datacolumn1] [ datacolumn2])=0,"",([datacolumn1][ datacolumn2])) |
Path: <datacolumn><datafield><numeric> Defines the settings of the column if <datafield type=”numeric”>. Attributes amount: Defines whether the amounts in the column are in unit or group currency. If the <currency> element is in use (in <datacolumn> or <area> settings), the value may be converted to a third currency or from unit currency to group currency. For more information, see <currency> and Currency Conversion. Possible values: •unit •group period: Defines whether the data in the column is periodical or cumulative. Possible values: •periodical •cumulative •Variable %PERIOD REPRESENTATION%: The option selected in the report template Advanced Options tab will be used. |
Example 1: Periodizing type sum Figure 25: Datafield settings - periodizing type sum Example 2: Periodizing type pattern Figure 26: Datafield settings - periodizing type pattern Example 3: Periodizing type periodizable Figure 27: Datafield settings - periodizing type periodizable Example 4: Report Figure 28: Datafield settings for report |