Format Strings

24 May 20192 minutes to read

IMPORTANT

This feature is applicable only for the relational data source at client mode.

Formatted numeric values like n (number with decimal points), c (currency or accounting), and p (percentage) can be displayed with desired decimal places by using the formatString.

Note: This is applicable only when the Format is set.

JS

<script>
$(function() {
   $("#PivotGrid1").ejPivotGrid({
        dataSource: {
            //..
            values: [
                {
                    fieldName: "Amount",
                    fieldCaption: "Amount",
                    format: "currency",
		            formatString:"{0:c0}"  //Specify the format string here
                }
            ]
        }
    });
 });
</script>

The following table describes the result of applying some commonly used format strings on numeric values:

Label Value	Label Format property value	Result	Description
1000	n1	1000.0	The Number is rounded to 1 decimal place
1000	n2	1000.00	The Number is rounded to 2 decimal place
1000	n3	1000.000	The Number is rounded to 3 decimal place
0.01	p1	1.0%	The Number is converted to percentage with 1 decimal place
0.01	p2	1.00%	The Number is converted to percentage with 2 decimal place
0.01	p3	1.000%	The Number is converted to percentage with 3 decimal place
1000	c1	$1,000.0	The Currency symbol is appended to number and number is rounded to 1 decimal place
1000	c2	$1,000.00	The Currency symbol is appended to number and number is rounded to 2 decimal place
1.0	d2	01	The number is rounded with 2 whole number place
1.0	d3	001	The number is rounded with 3 whole number place

The following table describes the result of applying some commonly used format strings on numeric values:

Format Pattern	Description	Result
d	The day of the month between 1 and 31.	"1"  to "31"
dd	The day of the month with leading zero if required.	"01" to "31"
ddd	Abbreviated day name.	"Mon" to "Sun"
dddd	The full day name	"Monday" to "Sunday"
M	The month of the year between 1 - 12	"1" to "12"
MM	The month of the year with leading zero if required	"01" to "12"
MMM	Abbreviated month name	"Jan" to "Dec"
MMMM	The full month name	"January" to "December"
yy	The year as a two-digit number	"99" or "08"
yyyy	The full four digit year	"1999" or "2008"
MM/dd/yyyy	The Date is displayed in "month/date/year" format	"04/09/1900"
d M, y	The Date is displayed in "date month, year" format	"7 9, 0"
d MM, y	The Date is displayed in "date month, year" format	"7 09, 0"
dddd, d MMMM, yy	The Date is displayed in "day, date month, year" format	"Tuesday, 7 September, 00"
yyyy-MM-dd	The Date is displayed in "year-month-date"(UTC) format	"1900-09-06"