Number Format

22 May 2017 / 2 minutes to read

Allows us to specify the required number format that PivotGrid should use in its values by setting the format option. Following number formats that are supported:

• number
• decimal
• currency
• percentage
• date
• time
• scientific
• accounting
• fraction

RELATIONAL

js

<script type="text/babel">
    var pivot_dataset = []; // data source
    var  pivotdataSource = {
        data: pivot_dataset, 
        //...
        values: [
                    { fieldName: "Amount", fieldCaption: "Amount", format: "currency" },
                    { fieldName: "Quantity", fieldCaption: "Quantity", format: "decimal" }
                ]
    };
</script>

OLAP

html

<script type="text/babel">
    var Olap_dataSource={
        //...
        values: [{ measures: [{ fieldName: "[Measures].[Internet Sales Amount]",
                                format: "percent" //Specify the format here 
                            }], 
                    axis: "columns" 
                }]    
    };  
</script>