{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"appanvil-karma-designer","parameters":{"macroParams":{"summary":{"value":" Format numbers This article focuses on how you can format numbers and apply conditional formatting logic in the visualizations you create via the BI tool. You can customize the format of the numbers for the metrics you add to your visualizations. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.For every metric, you can configure your own custom format using specific syntax or select from a variety of predefined formats. Select Predefined Number Formats in the Metric Editor Predefined formats for numbers are available when using the Metric Editor.Follow these steps:Select the dropdown next to Number format.Select a predefined format. Predefined Number Formats\tThe following table shows the predefined number formats: Note:Analytical Designer (AD) uses the format specified in the metric definition by default. You can overwrite the format when you are building your visualization in AD. Create a Custom Number Format in the Metric Editor A custom number format enables to you do the following for your metric:Select a specific format from various formatting templatesDefine your own number formatAdjust an already selected format.Follow these steps:Select the dropdown next to Number format.Select Custom. The **Custom Format** menu opens. 3. Edit the definition: * Insert your own, custom definition. * Select a template from the **Templates** menu.

$\"custom$

4. Select Apply.The format is applied to the metric. Digit Placeholders All number formats, whether predefined or custom, use the placeholders described in the following table: Preserve Extraneous ZeroesTo preserve extraneous zeros, use a 0 in place of the hash symbol (#) in the number formatting syntax.When # symbols are used in number formatting syntax, any zeros not holding a place value are removed. However, using a 0 in place of the # symbol in formatting syntax preserves extraneous zeros.Implications:#,##0.00: If the ones place is empty, a zero is displayed in its place.#,##0.00: If there are no tenths or hundredths places in a value, zeroes are displayed in those places.With this number formatting, the following are the results: Rounding to a Whole Number and Decimal PlacesThe number of hash symbols (#) to the right of the decimal point dictate the number of decimal place values to display. If the input number has more place values than specified by the formatting syntax, the final decimal place value is rounded. For example, #.# applied to 7.25 results in a display value of 7.3.To specify that decimal place values should be filled with zeros when null, use zeros in place of hash symbols for those decimal places in the number formatting syntax.Otherwise, zeros and hash symbols are interchangeable in number-formatting syntax. Separate Thousands, Millions, and so onInsert a comma between hash symbols in custom number formatting syntax to separate thousands in the sets of numbers (thousands, millions, billions, and so on). Truncating Large NumbersEvery comma added to the immediate left of the decimal point effectively truncates the number by another three place values, starting with the ones, tens, and hundreds places. You can provide context for truncated values by adding letters like K, M, and B (thousands, millions, and billions) to the custom number formatting syntax. These letters have no impact on the number’s value; the letter is just inserted in the output: Display Interpretable SymbolsYou can display symbols in your custom number formatting that might be otherwise interpreted by the GoodData Portal. To force the display of a literal in custom number formatting, precede the character with a backslash (\\).Suppose you want to display percentage symbols in your formatting. However, the percent symbol (%) has special meaning in custom formatting; it indicates that a data value should be multiplied by 100. If you add this symbol to the formatting, the value 97 is displayed as 9700%, instead of 97%.To display the percent symbol without affecting the data value, use the following in your formatting: %Some examples are listed below: Text Font ColorsText color formatting is applicable to tables and headline reports only.You can display report metric values in one of the following colors by inserting the color, between brackets [ ], at the start of the custom number syntax. For example:[Blue]#,#.##Available color codes:BlackBlueCyanGreenMagentaRedYellowWhiteYou can also use hexadecimal color codes with the following syntax:[color=99AE00]#,#.##Note:Do not insert a hash (#) symbol before the hexadecimal value. This voids your color formatting.Cell Background ColorYou can use hexadecimals to change the background color of cells with the following syntax:[backgroundcolor=00FF00]#,#.##To combine background color and font color syntax:[color=99AAEE][backgroundcolor=000000]#,#.##OR[red][backgroundcolor=000000]#,#.## Conditional number formatting Use conditional formatting to define a number’s color or number format, contingent upon its value. Conditions define the range of number values to which a certain format should be applied.Conditions are formed using brackets and their numerical ranges are defined using the symbols for the following:greater than (>)greater than or equal to (>=)less than (<)less than or equal to (<=)equal to (=)Conditional rules can be inserted anywhere formatting syntax, but they may be most helpful to place before formatting rules. The following example can be read as: “For number values less than or equal to 400,000, format in the following way…”[<=400000][backgroundcolor=CCCCCC][red]$#,#.##Separating Conditional Rules with SemicolonsYou can set multiple formatting rules that define formatting for different value ranges by using semicolons ( ; ) to separate rules. Consider the following example:[<600000][red]$#,#.##;[=600000][yellow]$#,#.##;[>600000][green]$#,#.##This syntax breaks down into the following rules. For all values less than 600,000: values are displayed in red font:[<600000][red]$#,#.##;For all values equal to 600,000: values are displayed in yellow font:[=600000][yellow]$#,#.##;For all values greater than 600,000: values are displayed in green font:[>600000][green]$#,#.##Overlapping ConditionsNote:Rules are always applied left-to-right. When two or more rules apply to the same range of values, the first listed rule overrules any other rules.Consider the following example rules (line-breaks added) where conditional formatting is used to create a temperature scale effect.[<400000][red]$#,#.##;[<500000][magenta]$#,#.##;[<600000][yellow]$#,#.##;[>=600000][green]$#,#.##These rules are interpreted in the following sequence.All values less than 400,000 are red.All values greater than or equal to 400,000 and less than 500,000 are magenta.All values greater than or equal to 500,000 and less than 600,000 are yellow.All values greater than or equal to 600,000 are green.Note:A number whose value is not treated by a condition is displayed in the default syntax ### and is not displayed with a font or background color.Using Conditionals with Negative NumbersNote:For data sets that include negative values, you must insert a negative symbol (-)in the formatting to explicitly format negative numbers.The following example number format (#,#) applies to all values less than 100. In this case, the value –70,000 is displayed as 70,000.[<100]#,#The syntax could be modified to explicitly address this issue. In this example, all values less than zero are formatted in red and preceded by a negative symbol.[<0][red]-#,#You might also decide to use additional symbols, like parentheses, to denote negative data values:[<0][red](#,#)Using Conditionals with Null ValuesBy default, cells with NULL values are left blank. You can also apply conditional formatting to cells with NULL values with the [=NULL] tag. In the following example, cells of null values are displayed with gray background color and “No Value” written in red font.[=Null][backgroundcolor=DDDDDD][red]No Value;Example: Automatically Round NumbersYou can use conditional formatting to automatically round and truncate numbers according to their value.The following syntax applies different formatting rules to values greater than or equal to one billion, between one million and one billion, and between one thousand and one million, as well to negative values of each of these ranges (line breaks added). Note the order in which the formatting rules are specified.[>=1000000000]#,,,.0 B; [>=1000000]#,,.0 M; [>=1000]#,.0 K; [>=0]#,##0 [<=-1000000000]-#,,,.0 B; [<=-1000000]-#,,.0 M; [<=-1000]-#,.0 K; [<0]-#,##0 Unit Conversion in Metric FormattingUnit conversion allows you to implement simple arithmetics to format metrics into various display outputs such as duration or length.For example, an input of seconds can show an output of HH:MM by converting seconds into hours and remaining minutes and applying the correct format on the result.FormatArithmetic format blocks can be included anywhere in the custom format string but they cannot be nested.They have the following structure:{{{div|mod|format}}}These blocks receive the same input number as the main formatting string that they are part of.Format blocks can be parameterized in the following way:div: The argument that divides the input number.mod: The modulo calculated from the result of the div calculation.format: The displayed output of the format applied to the input number divided by div modulo mod.Note:If mod does not end with dot (.), the decimal part of the number is stripped (therefore not rounded). Otherwise, the decimal part is preserved.Example: Display fact input values of seconds in days, hours, minutes, and seconds{{{86400||#}}} days\\, {{{3600|24|00}}}:{{{60|60|00}}}:{{{|60.|00.000}}} hoursGives the following results: Return to homepage"},"page":{"value":"{\"name\":\"page\",\"children\":[{\"params\":{\"background\":\"#0000\",\"padding\":20,\"gap\":10,\"image\":{\"value\":\"att456720389\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"image\",\"params\":{\"templateId\":\"square\",\"alignment\":\"center\",\"width\":100,\"height\":100,\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att448266262\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"DlQuqBrpnIt508COEfR7z\"},{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Format numbers\",\"fontSize\":22,\"lineHeight\":\"50px\",\"letterSpacing\":0,\"color\":\"#E6AC00\"}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"PUz07r-8Ds5Ook1g43Ejr\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":10,\"verticalAlignment\":\"center\"},\"id\":\"XwLGxDa_Sh4i2fXFJ6itX\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"jCL7hSKa4VnH8Yu4anIcS\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"CLLMQCVPmoHGypoKFj3Gn\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"VDsRlHdwCryJSF7KHlZPJ\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"ML2YmkM7hTAJshvmTQ4Hj\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"vvD4gCR3b6n-wtTXYgpyy\"}],\"params\":{\"layout\":[1],\"gap\":45,\"minHeight\":200,\"padding\":10,\"borderRadius\":0},\"id\":\"Gc5tJL87EnSR7JgbSiBqQ\"}],\"name\":\"section\",\"id\":\"EfigbweYEkmsWJwlFvQuh\"},{\"params\":{\"background\":\"#ffffff\",\"padding\":20,\"gap\":80},\"children\":[{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"letterSpacing\":0,\"text\":\"This article focuses on how you can format numbers and apply conditional formatting logic in the visualizations you create via the BI tool.\",\"fontFamily\":\"Poppins, sans-serif\",\"color\":\"#2A2A2A\",\"lineHeight\":\"50px\",\"fontSize\":18}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"SetmN4bmvv_3RiifmotCm\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"B_-iOc1r16NO4uUynXwF2\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"8wARM0h8WFKt046yZf8WU\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"x4ZOEpQgxpxOYVv_KgEu1\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"bGfumJHvzIWjFdM4Ai2mB\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"HkcUdqLWBNl3USHVVnsQo\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"QysjxUG_MKc1ViLf8tJaV\"}],\"params\":{\"layout\":[1],\"gap\":65,\"minHeight\":100,\"padding\":10,\"borderRadius\":0},\"id\":\"PkaHOTdKTvWYj5SwCLN17\"}],\"name\":\"section\",\"id\":\"yOj_iP11zttROC7hQWsbl\"},{\"id\":\"pf5bZ97O8s4NuBeNFQ1vL\",\"params\":{\"background\":{\"light\":\"#ffffff\",\"dark\":\"#1d2125\"},\"padding\":0,\"gap\":10},\"children\":[{\"id\":\"cSGWf3Rq7JO8LQ-lY7OB9\",\"name\":\"row\",\"children\":[{\"id\":\"MRZwEDM5L9T-o5jph2OL4\",\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can customize the format of the numbers for the metrics you add to your visualizations. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"For every metric, you can configure your own custom format using specific syntax or select from a variety of predefined formats.\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}],\"align\":\"left\"}]}]},\"children\":[],\"id\":\"DOZC0MnDbJLjitew2nTYR\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"Hm9eLo8Av6oeHq4N_GYGQ\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"v2MhLZTlMXyJtR9rCA98a\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"3IRUcSr0Dlj-WRUXIJeH7\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"HXiBcQqAWE65fvNfrLh5-\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"Sy4qt3EaXR2WznNmGi3_X\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}}],\"params\":{\"layout\":[1],\"gap\":10,\"minHeight\":100,\"padding\":10,\"borderRadius\":0}}],\"name\":\"section\"},{\"params\":{\"background\":\"#ffffff\",\"padding\":0,\"gap\":10},\"children\":[{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select Predefined Number Formats in the Metric Editor\",\"fontSize\":22,\"letterSpacing\":0,\"lineHeight\":\"35px\",\"color\":\"#2A2A2A\"}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"xJAo-c8m833FprO7aFlju\"},{\"name\":\"divider\",\"params\":{\"templateId\":\"solid short\",\"color\":{\"light\":\"#E6AC00\"},\"alignment\":\"center\",\"fontSize\":24,\"fontColor\":\"#000000\",\"height\":1,\"borderStyle\":\"solid\",\"width\":200},\"children\":[],\"id\":\"BZ9lluPVJFggNZI_ja_UI\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"CBk0Izh3RJz3xqeaEDfzt\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"AYPcVJM4SoZIhu6dN8TNC\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"PXiM0LAKCEh3Hg9shxbTx\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"niri5RpV0aT4sT3qFphCJ\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"AgC5mg6hjOUUab70LYJR2\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"jsneEbiCgOEw-ByuOb52z\"}],\"params\":{\"layout\":[1],\"gap\":100,\"minHeight\":80,\"padding\":10,\"borderRadius\":0},\"id\":\"Jo2X6As8-U4HJXYcmIme0\"}],\"name\":\"section\",\"id\":\"L17TNCOeIvSILyfO7_3xz\"},{\"id\":\"X--VdfC1FKTIkMtT92zsr\",\"params\":{\"background\":{\"light\":\"#ffffff\",\"dark\":\"#1d2125\"},\"padding\":0,\"gap\":10},\"children\":[{\"id\":\"cqyaiGlbCIVm8OGhlTCxq\",\"name\":\"row\",\"children\":[{\"id\":\"xOlXwbgjQz2FR3kJDi7GR\",\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Predefined formats for numbers are available when using the Metric Editor.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Follow these steps:\",\"fontSize\":18}]},{\"type\":\"numbered-list\",\"children\":[{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select the dropdown next to Number format.\",\"fontSize\":18}]},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select a predefined format.\",\"fontSize\":18}]}]}]}]},\"children\":[],\"id\":\"y1uQ2qgl3VD8lHAMWNyTO\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att659947522\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"iW5WQu7NDC_YMV99qv3Nv\"},{\"name\":\"text\",\"params\":{\"templateId\":\"headline and paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"text\":\"Predefined Number Formats\\t\",\"letterSpacing\":-1,\"lineHeight\":\"unset\",\"fontFamily\":\"Poppins, sans-serif\",\"color\":{\"light\":\"#555\"},\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"letterSpacing\":-1,\"lineHeight\":\"unset\",\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":16}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"The following table shows the predefined number formats:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"6d5Y6hjrVw4E-CA7EPwBo\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att659849228\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"86_qV78mszXSFaCjy2Bey\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Note:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Analytical Designer (AD) uses the format specified in the metric definition by default. You can overwrite the format when you are building your visualization in AD.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"Rq9SFU8A-Iu4x1rNAQO-3\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"CszKw3iIv_OCQYcw9MVYf\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"Vt0zyx-8plqQCAaDgIaV1\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"_hX8qtYb6bUND-TG3RPVX\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"g3Au5WpWpaQaHm2h5-I2R\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"tETsxegAKcWHZwKPKreNp\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}}],\"params\":{\"layout\":[1],\"gap\":10,\"minHeight\":200,\"padding\":10,\"borderRadius\":0}},{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Create a Custom Number Format in the Metric Editor \",\"fontSize\":22,\"letterSpacing\":0,\"lineHeight\":\"35px\",\"color\":\"#2A2A2A\"}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"ieRY2LbMOLO7tlHDtQ6Wt\"},{\"name\":\"divider\",\"params\":{\"templateId\":\"solid short\",\"color\":\"#E6AC00\",\"alignment\":\"center\",\"fontSize\":24,\"fontColor\":\"#000000\",\"height\":1,\"borderStyle\":\"solid\",\"width\":200},\"children\":[],\"id\":\"4vP6WyW_smjxxRBqhL01L\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"A custom number format enables to you do the following for your metric:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"numbered-list\",\"children\":[{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select a specific format from various formatting templates\",\"fontSize\":18}]},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Define your own number format\",\"fontSize\":18}]},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Adjust an already selected format.\",\"fontSize\":18}]}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Follow these steps:\",\"fontSize\":18}]},{\"type\":\"numbered-list\",\"children\":[{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select the dropdown next to Number format.\",\"fontSize\":18}]},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Select Custom.\",\"fontSize\":18}]}]}]}]},\"children\":[],\"id\":\"3AgnWy8m2BW8mL5RYBFdb\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660406273\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"dpZItTnYRuwjv5ZKzfCAY\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"The **Custom Format** menu opens. \",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"3. Edit the definition: * Insert your own, custom definition. * Select a template from the **Templates** menu.\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"left\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"left\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"

\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"left\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"left\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"4. Select Apply.\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"The format is applied to the metric.\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]}]}]}]},\"children\":[],\"id\":\"1pB7kgzfOW25XG4GXeKm1\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"JR8qnVECd8hgTX9mjemk5\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"ZFR7MFVeRRR7LplnInwII\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"WjQcbKiHG-8CxjSnqmxVM\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"mPOuDBpOR7ZzvKGkqQhua\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"lUFdgK5KWfgcOtdx32m9k\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"30lD9KdbcikUJ6Wbbo2Fh\"}],\"params\":{\"layout\":[1],\"gap\":100,\"minHeight\":80,\"padding\":10,\"borderRadius\":0},\"id\":\"HChb7b4ZIcFvwwBwq4GCm\"},{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Digit Placeholders\",\"fontSize\":22,\"letterSpacing\":0,\"lineHeight\":\"35px\",\"color\":\"#2A2A2A\"}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"d2a8CaHrGATPcrzaa3JLl\"},{\"name\":\"divider\",\"params\":{\"templateId\":\"solid short\",\"color\":\"#E6AC00\",\"alignment\":\"center\",\"fontSize\":24,\"fontColor\":\"#000000\",\"height\":1,\"borderStyle\":\"solid\",\"width\":200},\"children\":[],\"id\":\"j4lni8H-daPlm_nlF7fNE\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"All number formats, whether predefined or custom, use the placeholders described in the following table:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]}]}]}]},\"children\":[],\"id\":\"o1THCYIThTM9n87dYod38\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660373507\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"LItJ8SLSftTZtJ4pzLS45\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Preserve Extraneous Zeroes\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\"}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"To preserve extraneous zeros, use a 0 in place of the hash symbol (#) in the number formatting syntax.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"When # symbols are used in number formatting syntax, any zeros not holding a place value are removed. However, using a 0 in place of the # symbol in formatting syntax preserves extraneous zeros.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Implications:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"#,##0.00: If the ones place is empty, a zero is displayed in its place.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"#,##0.00: If there are no tenths or hundredths places in a value, zeroes are displayed in those places.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"With this number formatting, the following are the results:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"Inq0osQJMC1ZKGjUDhlUu\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660078594\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"kGtU-d30hsn-plbzeKuSp\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Rounding to a Whole Number and Decimal Places\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20,\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"The number of hash symbols (#) to the right of the decimal point dictate the number of decimal place values to display. If the input number has more place values than specified by the formatting syntax, the final decimal place value is rounded. For example, #.# applied to 7.25 results in a display value of 7.3.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"To specify that decimal place values should be filled with zeros when null, use zeros in place of hash symbols for those decimal places in the number formatting syntax.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Otherwise, zeros and hash symbols are interchangeable in number-formatting syntax.\",\"fontSize\":18}]}]}]},\"children\":[],\"id\":\"FVqAgkeQVEZD7Fecu_gwT\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660471811\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"xj8TB6iwliMKDNLBt8aqx\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Separate Thousands, Millions, and so on\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20,\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Insert a comma between hash symbols in custom number formatting syntax to separate thousands in the sets of numbers (thousands, millions, billions, and so on).\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18,\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"dTctaMLmgA2TDkG2SPoc6\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660340738\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"o25CET_djIGOYOSQgj0YU\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Truncating Large Numbers\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":16,\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Every comma added to the immediate left of the decimal point effectively truncates the number by another three place values, starting with the ones, tens, and hundreds places.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":16,\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"hdWISZWjAjWKSESJ2Y1LS\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660340744\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"3VQUTDzTXlMkqCu132UyL\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can provide context for truncated values by adding letters like K, M, and B (thousands, millions, and billions) to the custom number formatting syntax. These letters have no impact on the number’s value; the letter is just inserted in the output:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"30y8b69dViU89SY-eo6jZ\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660471817\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"4hK2ojrhh6pRdr8tveuV0\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Display Interpretable Symbols\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can display symbols in your custom number formatting that might be otherwise interpreted by the GoodData Portal. To force the display of a literal in custom number formatting, precede the character with a backslash (\\\\).\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Suppose you want to display percentage symbols in your formatting. However, the percent symbol (%) has special meaning in custom formatting; it indicates that a data value should be multiplied by 100. If you add this symbol to the formatting, the value 97 is displayed as 9700%, instead of 97%.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"To display the percent symbol without affecting the data value, use the following in your formatting: %\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Some examples are listed below:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"_g9IR_4L_R6s5GYu9_Lre\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660209667\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"n0y6dmSGUnfmPETYEElx_\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Text Font Colors\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20,\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Text color formatting is applicable to tables and headline reports only.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can display report metric values in one of the following colors by inserting the color, between brackets [ ], at the start of the custom number syntax. For example:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[Blue]#,#.##\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Available color codes:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Black\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Blue\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Cyan\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Green\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Magenta\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Red\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Yellow\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"White\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can also use hexadecimal color codes with the following syntax:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[color=99AE00]#,#.##\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Note:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Do not insert a hash (#) symbol before the hexadecimal value. This voids your color formatting.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":20}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Cell Background Color\",\"fontSize\":20}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"You can use hexadecimals to change the background color of cells with the following syntax:\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"[backgroundcolor=00FF00]#,#.##\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"To combine background color and font color syntax:\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"[color=99AAEE][backgroundcolor=000000]#,#.##\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"OR\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"[red][backgroundcolor=000000]#,#.##\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"DezFXgDhBqvOdPm62pIxp\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"rwFPT2Fb7raA2tfiVDU6S\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"PsnuIEQJjGwaZ1OOjjK5L\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"zUYacClfMVN7RSKu7gNb_\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"vKiuyMWZtiMJ8g6pToyeE\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"FiDe2rKC2Kdh_252UA_0c\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"ErlX6a9qKXSe_Afia2Pct\"}],\"params\":{\"layout\":[1],\"gap\":100,\"minHeight\":80,\"padding\":10,\"borderRadius\":0},\"id\":\"MF2YKBy5ZAiebXJc8Svlu\"}],\"name\":\"section\"},{\"params\":{\"background\":\"#ffffff\",\"padding\":0,\"gap\":10},\"children\":[{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Conditional number formatting\",\"fontSize\":22,\"letterSpacing\":0,\"lineHeight\":\"35px\",\"color\":\"#2A2A2A\"}],\"align\":\"center\"}]}]},\"children\":[],\"id\":\"EQAJwn7kr1DLrhEni7onq\"},{\"name\":\"divider\",\"params\":{\"templateId\":\"solid short\",\"color\":\"#E6AC00\",\"alignment\":\"center\",\"fontSize\":24,\"fontColor\":\"#000000\",\"height\":1,\"borderStyle\":\"solid\",\"width\":200},\"children\":[],\"id\":\"Q6f20sE_q6AZdK2EqfYl-\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"CGedqCC9OLVdsZ-N4ITRP\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"O0VZYpZvVur46EHusHOZY\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"sG3SSvUO13Sp2mNbytmKJ\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"YTPLjxLsxpdUeqVhbweyP\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"aPj2wj6-7OFygDRYu4eer\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"ejQ5vEwYJl-dlqWZ1Oe9N\"}],\"params\":{\"layout\":[1],\"gap\":100,\"minHeight\":80,\"padding\":10,\"borderRadius\":0},\"id\":\"zr_KgRTrRUkgpIL2cUujM\"}],\"name\":\"section\",\"id\":\"CpWuV4XC9PnSE2LvOM69M\"},{\"id\":\"d-7HpuA769sQqMaKVXatB\",\"params\":{\"background\":{\"light\":\"#ffffff\",\"dark\":\"#1d2125\"},\"padding\":0,\"gap\":10},\"children\":[{\"id\":\"0Jf5PjyHWUO0nIxy3Vb_d\",\"name\":\"row\",\"children\":[{\"id\":\"IFEWQ1vMWgkBH7d2l2TJF\",\"name\":\"column\",\"children\":[{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Use conditional formatting to define a number’s color or number format, contingent upon its value. Conditions define the range of number values to which a certain format should be applied.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Conditions are formed using brackets and their numerical ranges are defined using the symbols for the following:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"greater than (>)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"greater than or equal to (>=)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"less than (<)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"less than or equal to (<=)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"equal to (=)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Conditional rules can be inserted anywhere formatting syntax, but they may be most helpful to place before formatting rules. The following example can be read as: “For number values less than or equal to 400,000, format in the following way…”\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<=400000][backgroundcolor=CCCCCC][red]$#,#.##\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Separating Conditional Rules with Semicolons\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can set multiple formatting rules that define formatting for different value ranges by using semicolons ( ; ) to separate rules. \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Consider the following example:\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"[<600000][red]$#,#.##;[=600000][yellow]$#,#.##;[>600000][green]$#,#.##\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"This syntax breaks down into the following rules. \",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"For all values less than 600,000: values are displayed in red font:\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<600000][red]$#,#.##;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"For all values equal to 600,000: values are displayed in yellow font:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[=600000][yellow]$#,#.##;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"For all values greater than 600,000: values are displayed in green font:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>600000][green]$#,#.##\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Overlapping Conditions\",\"fontSize\":20}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Note:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Rules are always applied left-to-right. When two or more rules apply to the same range of values, the first listed rule overrules any other rules.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Consider the following example rules (line-breaks added) where conditional formatting is used to create a temperature scale effect.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<400000][red]$#,#.##;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<500000][magenta]$#,#.##;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<600000][yellow]$#,#.##;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>=600000][green]$#,#.##\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"These rules are interpreted in the following sequence.\",\"fontSize\":18}]},{\"type\":\"numbered-list\",\"children\":[{\"type\":\"list-item\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"All values less than 400,000 are red.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"list-item\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"All values greater than or equal to 400,000 and less than 500,000 are magenta.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"list-item\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"All values greater than or equal to 500,000 and less than 600,000 are yellow.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"list-item\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"All values greater than or equal to 600,000 are green.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Note:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"A number whose value is not treated by a condition is displayed in the default syntax ### and is not displayed with a font or background color.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Using Conditionals with Negative Numbers\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Note:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"For data sets that include negative values, you must insert a negative symbol (-)in the formatting to explicitly format negative numbers.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"The following example number format (#,#) applies to all values less than 100. In this case, the value –70,000 is displayed as 70,000.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"[<100]#,#\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"The syntax could be modified to explicitly address this issue. In this example, all values less than zero are formatted in red and preceded by a negative symbol.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<0][red]-#,#\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You might also decide to use additional symbols, like parentheses, to denote negative data values:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<0][red](#,#)\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Using Conditionals with Null Values\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"By default, cells with NULL values are left blank. You can also apply conditional formatting to cells with NULL values with the [=NULL] tag. In the following example, cells of null values are displayed with gray background color and “No Value” written in red font.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[=Null][backgroundcolor=DDDDDD][red]No Value;\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Example: Automatically Round Numbers\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20,\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"You can use conditional formatting to automatically round and truncate numbers according to their value.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"The following syntax applies different formatting rules to values greater than or equal to one billion, between one million and one billion, and between one thousand and one million, as well to negative values of each of these ranges (line breaks added). Note the order in which the formatting rules are specified.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>=1000000000]#,,,.0 B; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>=1000000]#,,.0 M; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>=1000]#,.0 K; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[>=0]#,##0 \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<=-1000000000]-#,,,.0 B; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<=-1000000]-#,,.0 M; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<=-1000]-#,.0 K; \",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"[<0]-#,##0\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Open Sans, sans-serif\",\"text\":\"\"}]}]}]},\"children\":[],\"id\":\"WaDAWERRgWa7Y2JqMs0cv\"},{\"name\":\"text\",\"params\":{\"templateId\":\"simple paragraph\",\"value\":[{\"type\":\"paragraph\",\"children\":[{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Unit Conversion in Metric Formatting\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"fontSize\":16,\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\"}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Unit conversion allows you to implement simple arithmetics to format metrics into various display outputs such as duration or length.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"For example, an input of seconds can show an output of HH:MM by converting seconds into hours and remaining minutes and applying the correct format on the result.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Format\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Arithmetic format blocks can be included anywhere in the custom format string but they cannot be nested.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"They have the following structure:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"{{{div|mod|format}}}\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"These blocks receive the same input number as the main formatting string that they are part of.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Format blocks can be parameterized in the following way:\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"numbered-list\",\"children\":[{\"type\":\"list-item\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"div: The argument that divides the input number.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"mod: The modulo calculated from the result of the div calculation.\",\"fontSize\":18}]},{\"type\":\"list-item\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"format: The displayed output of the format applied to the input number divided by div modulo mod.\",\"fontSize\":18}]}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Note:\",\"fontSize\":18}]},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"If mod does not end with dot (.), the decimal part of the number is stripped (therefore not rounded). Otherwise, the decimal part is preserved.\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"Example: Display fact input values of seconds in days, hours, minutes, and seconds\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":20}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"{{{86400||#}}} days\\\\, {{{3600|24|00}}}:{{{60|60|00}}}:{{{|60.|00.000}}} hours\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"text\":\"\",\"fontFamily\":\"Poppins, sans-serif\",\"fontSize\":18}],\"align\":\"center\"},{\"type\":\"paragraph\",\"align\":\"center\",\"children\":[{\"lineHeight\":\"24px\",\"color\":\"#555\",\"letterSpacing\":0,\"fontFamily\":\"Poppins, sans-serif\",\"text\":\"Gives the following results:\",\"fontSize\":18}]}]}]},\"children\":[],\"id\":\"zjh6D4HLVs1pNg2F31ZZM\"},{\"name\":\"image\",\"params\":{\"templateId\":\"full-width rounded\",\"alignment\":\"center\",\"position\":\"center center\",\"borderRadius\":{\"all\":20,\"bbl\":0,\"bbr\":0,\"btl\":0,\"btr\":0,\"isIndividualCorners\":false},\"image\":{\"value\":\"att660439043\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[],\"id\":\"EOR7Jeatpye3fg2Xj29uj\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"Fa-tTPBgHCRtPXHDX-I_3\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"EncKZneSLftqxU_wRz_T-\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"3uD2CWnlO8Q8EycAVPLU2\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"nB_WbrpX6Mvv8cqm-qVZS\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}},{\"id\":\"LNJNaSY8HHJUREqN40plv\",\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"top\"}}],\"params\":{\"layout\":[1],\"gap\":10,\"minHeight\":200,\"padding\":10,\"borderRadius\":0}}],\"name\":\"section\"},{\"params\":{\"background\":\"#ffffff\",\"padding\":20,\"gap\":80},\"children\":[],\"name\":\"section\",\"id\":\"VMfmdpW-XuZX_kWHWxmfm\"},{\"params\":{\"background\":\"#0000\",\"padding\":20,\"gap\":10,\"image\":{\"value\":\"att456720389\",\"target\":\"_blank\",\"type\":\"attachment\"}},\"children\":[{\"name\":\"row\",\"children\":[{\"name\":\"column\",\"children\":[{\"name\":\"divider\",\"params\":{\"color\":\"#E6AC00\",\"alignment\":\"center\",\"fontSize\":24,\"fontColor\":\"#000000\",\"height\":3,\"borderStyle\":\"solid\",\"width\":100},\"children\":[],\"id\":\"5WO5I2HDDF1VIkrEY9GWw\"},{\"name\":\"button\",\"params\":{\"templateId\":\"regular button\",\"label\":\"Return to homepage\",\"size\":\"medium\",\"shape\":\"circular\",\"alignment\":\"center\",\"states\":{\"idle\":{\"colors\":{\"background\":\"#E6AC00\",\"label\":\"#ffffff\"}},\"hover\":{\"colors\":{}}},\"link\":{\"value\":\"https://learnamp.atlassian.net/wiki/spaces/KB/overview\",\"target\":\"_blank\",\"type\":\"link\"}},\"children\":[],\"id\":\"bPO3GYdpJDED9tHJPlbx4\"}],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":10,\"verticalAlignment\":\"center\"},\"id\":\"je0xt31IiqUZPuuOCJGfc\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"3ibibcq_tNxIj9oM7KrzF\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"m0nY6YmDSq2JAnRecfLLT\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"8WGSj1Uw-RgDyj4aw3uKQ\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"BqIy6j9kFhDSrbIh7JF6H\"},{\"name\":\"column\",\"children\":[],\"params\":{\"borderRadius\":{\"all\":0,\"btl\":0,\"bbl\":0,\"btr\":0,\"bbr\":0,\"isIndividualCorners\":false},\"padding\":0,\"gap\":20,\"verticalAlignment\":\"center\"},\"id\":\"wXU_fzjZP6ShO8keCRyRV\"}],\"params\":{\"layout\":[1],\"gap\":45,\"minHeight\":200,\"padding\":10,\"borderRadius\":0},\"id\":\"tzv1IGXw7nBAMdB0nHcP2\"}],\"name\":\"section\",\"id\":\"_SFXkwgweFAlGuyK8bwmT\"}],\"id\":\"kMycoNWsGroObg4qvfXIO\"}"}},"macroMetadata":{"macroId":{"value":"c34202af-63cc-4ee8-a2f4-b4c7ec1189f8"},"schemaVersion":{"value":"1"},"indexedMacroParams":{"text":" Format numbers This article focuses on how you can format numbers and apply conditional formatting logic in the visualizations you create via the BI tool. You can customize the format of the numbers for the metrics you add to your visualizations. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.For every metric, you can configure your own custom format using specific syntax or select from a variety of predefined formats. Select Predefined Number Formats in the Metric Editor Predefined formats for numbers are available when using the Metric Editor.Follow these steps:Select the dropdown next to Number format.Select a predefined format. Predefined Number Formats\tThe following table shows the predefined number formats: Note:Analytical Designer (AD) uses the format specified in the metric definition by default. You can overwrite the format when you are building your visualization in AD. Create a Custom Number Format in the Metric Editor A custom number format enables to you do the following for your metric:Select a specific format from various formatting templatesDefine your own number formatAdjust an already selected format.Follow these steps:Select the dropdown next to Number format.Select Custom. The **Custom Format** menu opens. 3. Edit the definition: * Insert your own, custom definition. * Select a template from the **Templates** menu.

$\"custom$