{"id":1621,"date":"2015-09-23T15:47:51","date_gmt":"2015-09-23T14:47:51","guid":{"rendered":"http:\/\/help.instantatlas.com\/report-builder-agol\/?page_id=1621"},"modified":"2015-09-23T15:47:51","modified_gmt":"2015-09-23T14:47:51","slug":"number-formats","status":"publish","type":"page","link":"https:\/\/help.reports.esriuk.com\/report-builder\/number-formats\/","title":{"rendered":"Number Formats"},"content":{"rendered":"

Generally you want to display numbers in a more friendly format than that found in your raw data.<\/p>\n

Report Builder gives you access to format strings enabling you to transform your numeric data\u00a0however you see fit. Below is a table of commonly used format strings.<\/p>\n\n\n\n\n\n
Description<\/strong><\/td>\nFormat<\/strong><\/td>\n<\/td>\n<\/tr>\n
Millions<\/td>\n\n
0,,M<\/pre>\n<\/td>\n
<\/td>\n<\/tr>\n
Millions With Decimal<\/td>\n\n
0,,.0M<\/span><\/pre>\n<\/td>\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Format Strings General Reference<\/h2>\n\n\n\n\n\n\n\n\n\n
Format<\/th>\nDescription<\/th>\nExample<\/th>\n<\/tr>\n<\/thead>\n
“N” – Number<\/td>\nIntegral and decimal digits, group separators, and a decimal separator with optional negative sign.<\/td>\n1234.567 (“N”, en-US) -> 1,234.57
\n1234.567 (“N”, ru-RU) -> 1 234,57<\/td>\n<\/tr>\n
“C” – Currency<\/td>\nA currency value – can be used with any number.<\/td>\n123.456 (“C”, en-US) -> $123.46
\n123.456 (“C”, fr-FR) -> 123,46 \u20ac
\n123.456 (“C”, ja-JP) -> \u00a5123<\/td>\n<\/tr>\n
“G” – General<\/td>\nThe most compact of either fixed-point or scientific notation.<\/td>\n-123.456 (“G”, en-US) -> -123.456
\n123.456 (“G”, sv-SE) -> -123,456
\n-1.234567890e-25 (“G”, en-US) -> -1.23456789E-25
\n-1.234567890e-25 (“G”, sv-SE) -> -1,23456789E-25<\/td>\n<\/tr>\n
“P” – Percentage<\/td>\nNumber multiplied by 100 and displayed with a percent symbol.<\/td>\n1 (“P”, en-US) -> 100.00 %
\n1 (“P”, fr-FR) -> 100,00 %
\n-0.39678 (“P”, en-US) -> -39.68 %
\n-0.39678 (“P”, fr-FR) -> -39,68 %<\/td>\n<\/tr>\n
Custom<\/td>\nYour custom number format. Certain characters have special meanings:<\/p>\n
    \n
  • 0<\/span><\/code> – forces a digit to display e.g. with a value of 0.1<\/span><\/code> and a format of 0.00<\/span><\/code> the formatted value<\/em> would be 0.10<\/span><\/code><\/li>\n
  • #<\/span><\/code> – display a digit if present e.g. with a value of 0.1<\/span><\/code> and a format of #.##<\/span><\/code> the formatted value<\/em> would be .1<\/span><\/code><\/li>\n
  • .<\/span><\/code> – display a decimal point if necessary e.g. with a value of 1.1<\/span><\/code> and a format of #.#<\/span><\/code> the formatted value<\/em> would be 1.1<\/span><\/code> but with a format of #<\/span><\/code> the formatted value<\/em> would be 1<\/span><\/code><\/li>\n
  • ,<\/span><\/code> – display a digit separator if necessary e.g. with a value of 1000<\/span><\/code> and a format of #,###<\/span><\/code> the formatted value<\/em> would be 1,000<\/span><\/code> in English or 1 000<\/span><\/code> in Spanish<\/li>\n<\/ul>\n

    More details on custom number formats can be found on MSDN<\/span><\/u><\/a>.<\/td>\n

1000 (“#,###.#”, en-US) -> 1,000
\n1000 (“#,###.#”, fr-FR) -> 1 000
\n-3.9 (“#.#0”, en-US) -> -3.90
\n-3.9 (“#.#0”, fr-FR) -> -3,90<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Generally you want to display numbers in a more friendly format than that found in your raw data. Report Builder gives you access to format strings enabling you to transform your numeric data\u00a0however you see fit. Below is a table of commonly used format strings. Description Format Millions 0,,M Millions With Decimal 0,,.0M Format Strings […]<\/p>\n","protected":false},"author":61,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1621","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/1621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/comments?post=1621"}],"version-history":[{"count":0,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/1621\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/media?parent=1621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}