FineBI Version
7.0
/
7.0.6
Added multiple formats for Quantity Unit.
Added the Value Format configuration item.
You need to configure the value format for indicators or data values.
For indicators of group tables and cross tables, as well as data fields of detail tables, FineBI provides the Value Format function, allowing you to set field values to be in three types of formats: Auto, Number, and Percentage.
Auto
Quantity Unit, Unit Suffix, Value Format, and Permille Sign
Number
Decimal Place, Quantity Unit, Unit Suffix, Value Format, and Permille Sign
Percentage
Decimal Place, Unit Suffix, Value Format, Permille Sign, and Display Table Header Unit
The function is supported in the group table, cross table, and detail table.
The value format configurations are subject to the system language, and optional formats vary across different languages. You need to set the system language in advance if you have special formatting requirements. Otherwise, you can skip this step.
Multiple value formats for multiple countries are added in FineBI V7.0.6. You can configure the region in advance, as shown in the following figure.
Region description:
The lowercase letters represent language codes. For details, see ISO 639-1.
The uppercase letters represent country and region codes. For details, see ISO 3166-1.
1. These configurations only affect date and value formats, and do not impact the translation of other contents.
2. Language priority: personal settings > multilingual plugin settings > browser language > project language
1. Log in to the FineBI system, click My Analysis, select a data folder, and click New Subject to create an analysis subject, as shown in the following figure.
2. Choose Local Excel > Upload Data and upload the required data, as shown in the following figure.
Example data: Contract Fact Table.xlsx
3. After successful uploading, click OK to enter the data editing page, as shown in the following figure.
4. On the data editing page, click Save and Update to save and update the data of the analysis subject. You can click Preview to preview the data, as shown in the following figure.
1. Click the Component button in the lower-left corner to add a component.
2. Select Group Table in Chart Type.
3. Drag the Contract Type and Contract Payment Type fields into the Dimension bar and drag the Purchase Quantity and Total Amount fields into the Indicator bar, as shown in the following figure.
1. Click the drop-down icon of a numeric field, for example, Total Amount, in the Indicator bar (or Data bar for detail tables) of the analysis area, and select Value Format, as shown in the following figure.
2. On the value format setting page, three types of value formats are available, namely Auto, Number, and Percentage. Auto is selected by default, as shown in the following figure.
Quantity Unit
FineBI of versions earlier than 7.0.6 support the following units: None, Thousand, Million, and Billion.
Starting from FineBI V7.0.6, units displayed vary by language.
1. Chinese/Japanese/Korean: Thousand, Ten Thousand, Million, Ten Million, and Hundred Million
2. Hindi: Thousand, Hundred Thousand, Ten Million, and Billion
3. Other Language (except English): Thousand, Million, and Billion
4. English: Thousand, Million, and Billion
The default quantity unit is None.
Unit Suffix
The value is left blank by default and allows you to customize numeric units as needed.
Value Format
Four formats are available, with different default values for different countries or regions:
1. For China, Japan, South Korea, the United States, the United Kingdom, and Arabic-speaking regions, the default format is #,##0.##, for example, 1,234,567.89.
2. For Russia and France, the default format is # ##0,##, for example, 1 234 567,89.
3. For Indonesia, Vietnam, and Germany, the default format is #.##0,##, for example, 1.234.567,89.
4. For India, the default format is #,##,##0.##, for example, 12,34,567.89.
Permille Sign
You can select or deselect Permille Sign.
For example, you can set Quantity Unit to Million, Unit Suffix to Dollar, and Value Format to Default(#,##0.##), and check Permille Sign. In this case, the preview effect will be displayed below the configuration items. You can click OK to complete the configuration, as shown in the following figure.
The Decimal Place configuration item, which is not available in Auto, is added in Number, allowing you to configure the number of decimal places displayed for indicator values (or data values in detail tables).
By default, Decimal Place is set to 2, Quantity Unit is set to None, Unit Suffix is left blank, Value Format is set to Default(#,##0.##), and Permille Sign is selected, as shown in the following figure.
For example, you can set Decimal Place to 4, Quantity Unit to Million, and Unit Suffix to Dollar, adopt the default value format (#,##0.##), and select Permille Sign. In this case, the preview effect will be displayed below the configuration items. You can click OK to complete the configuration, as shown in the following figure.
The Display Table Header Unit configuration item, which is not available in Number, is added in Percentage, where the Quantity Unit configuration item is not available.
By default, Decimal Place is set to 2, Unit Suffix is left blank, Value Format is set to Default(#,##0.##), and Permille Sign is selected while Display Table Header Unit is not selected, as shown in the following figure.
After selecting multiple fields using Ctrl or Shift, you can configure Value Format for all selected fields in batches.
In this example, you can set Quantity Unit for the Sales Amount and Profit fields to Thousand, as shown in the following figure.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy