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