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
export class BasicUse {
constructor() {
this.pivotData = {
//..
values: [{
measures: [{
fieldName: "[Measures].[Internet Sales Amount]",
format: "percent" //Specify the format here
}],
axis: "columns"
}]
}
}
}
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page