Number Format

27 Feb 2018 / 2 minutes to read

IMPORTANT

This feature is applicable for all modes.

Allows you to specify the required number format that should be used in values of the PivotGrid by setting the format. Following are supported number formats:

number
decimal
currency
percentage
date
time
scientific
accounting
fraction
string

Relational

export class BasicUse {
  constructor() {
    this.pivotData = {
            //..
            values: [
                {
                    fieldName: "Amount",
                    fieldCaption: "Amount",
                    format: "currency" //Specify the format here
                },
                {
                    fieldName: "Quantity",
                    fieldCaption: "Quantity",
                    format: "decimal"
                }
            ]
        }
    }
 }

OLAP

html

export class BasicUse {
  constructor() {
    this.pivotData = {
        //..
        values: [{
            measures: [{
                fieldName: "[Measures].[Internet Sales Amount]",
                format: "percent" //Specify the format here
            }],
            axis: "columns"
        }]
    }
  }
}