Apply User Locale Settings mentioned above. This option will be disabled when you have chosen. This option will be enabled for a number and decimal type columns. Thousand - This option can be used to select the type of thousand separator.

For example, in US locale a comma will be used for a thousand separator and in case of German locale a dot will be used. This option allows you to pick a decimal and thousand separators to be used.Īpply User Locale Settings - You can select this option to use separators based on the locale settings of the user. Possible values are l eft, right and center. This option can be used to horizontally align the value in the cell. Now, this is how the report will look like. Also, please do note that the formatting options in this dialog will change based on the data type of the column. This will limit the units after the decimal point to two.Īpart from decimal places, there are various other options that you can use to customize your data. In the format column dialog that appears, choose ' 2' from the drop-down that is available next to Decimal Places.Right-click the Sales column and select Format Column.Let us now see how to resolve this issue. This is where data formatting comes in handy. In the above chart, the data labels with extended decimal values make it difficult to interpret the chart. We are going to create a report to show the total sales done in each month. Let us now create a report using this data. This can be a major step back while analyzing a large amount of data. In the below image the data in the ' Sales' column are not formatted. The Data Formatting options selected for the data values in your columns are applied across all visualizations in Zoho Analytics. This allows you to standardize the data in your table, thereby enabling easy interpretation and analysis. Zoho Analytics offers various options to format the data in your columns.

Filemaker pro 16 value list formatting