{"id":11259,"date":"2023-04-29T17:14:40","date_gmt":"2023-04-29T17:14:40","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=11259"},"modified":"2023-04-29T17:14:48","modified_gmt":"2023-04-29T17:14:48","slug":"decimal-value-as-a-percentage-in-d365-bc","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/decimal-value-as-a-percentage-in-d365-bc\/","title":{"rendered":"How to Display the Decimal Value as a Percentage in D365 BC"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Display the Decimal Value as a Percentage in D365 BC:<\/h2>\n\n\n\n<p>(1) In this blog we will get to know about the conversion of decimal values into percentages in D365 BC by using these properties:<\/p>\n\n\n\n<ul>\n<li>AutoFormatType.<\/li>\n\n\n\n<li>AutoFormatExpression.<\/li>\n<\/ul>\n\n\n\n<p>(2) For this <a href=\"https:\/\/erpconsultors.com\/creation-of-table-in-dynamics-365-bc\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><em>create a field in the table<\/em><\/strong><\/a>, as shown.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"603\" data-attachment-id=\"11268\" data-permalink=\"https:\/\/erpconsultors.com\/create-a-field-in-the-table-in-d365-bc\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?fit=474%2C603&amp;ssl=1\" data-orig-size=\"474,603\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"create a field in the table in d365 bc\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?fit=236%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?fit=474%2C603&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?resize=474%2C603&#038;ssl=1\" alt=\"create a field in the table in d365 bc\" class=\"wp-image-11268\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?w=474&amp;ssl=1 474w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/create-a-field-in-the-table-in-d365-bc.png?resize=236%2C300&amp;ssl=1 236w\" sizes=\"(max-width: 474px) 100vw, 474px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n<p>(3) After creating a field in the table, show that field on the page with these properties, as shown.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"581\" height=\"542\" data-attachment-id=\"11270\" data-permalink=\"https:\/\/erpconsultors.com\/show-field-on-the-page-with-these-properties-in-d365-bc\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?fit=581%2C542&amp;ssl=1\" data-orig-size=\"581,542\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"show field on the page with these properties in d365 bc\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?fit=300%2C280&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?fit=581%2C542&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?resize=581%2C542&#038;ssl=1\" alt=\"show field on the page with these properties in d365 bc\" class=\"wp-image-11270\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?w=581&amp;ssl=1 581w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/show-field-on-the-page-with-these-properties-in-d365-bc.png?resize=300%2C280&amp;ssl=1 300w\" sizes=\"(max-width: 581px) 100vw, 581px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n<p>(4) Notes from Microsoft: If you want to display the decimal value as a percentage, then you can add % at the end of the setting. For example:<\/p>\n\n\n\n<ul>\n<li>AutoFormatType = 10;<\/li>\n\n\n\n<li>AutoFormatExpression = &#8216;&lt;precision, 1:1&gt;&lt;standard format,0&gt;%&#8217;<\/li>\n\n\n\n<li>When you include a % at the end of the setting, then the decimal value is assumed to be the ratio, and the decimal value will be multiplied by 100. For example, a value of 0.98 will be formatted to 98%.<\/li>\n\n\n\n<li>For more information refer to this link- <strong><a href=\"https:\/\/learn.microsoft.com\/en-us\/dynamics365\/business-central\/dev-itpro\/developer\/devenv-format-field-data#setting-the-autoformatexpression-property\" target=\"_blank\" rel=\"noreferrer noopener\"><em>Setting the AutoFormatExpression property<\/em><\/a><\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>(5) After doing the above steps, publish the extension and check the result, as shown.<\/p>\n\n\n\n<ul>\n<li>Enter 0.234 in the field \u201cDecimal value as Percentage\u201d and the system auto convert it into 23.40%, as shown<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"11273\" data-permalink=\"https:\/\/erpconsultors.com\/decimal-value-as-a-percentage-in-d365-bc\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?fit=859%2C474&amp;ssl=1\" data-orig-size=\"859,474\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Decimal Value as a Percentage in D365 BC\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?fit=300%2C166&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?fit=655%2C361&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?resize=655%2C361&#038;ssl=1\" alt=\"Decimal Value as a Percentage in D365 BC\" class=\"wp-image-11273\" width=\"655\" height=\"361\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?w=859&amp;ssl=1 859w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?resize=300%2C166&amp;ssl=1 300w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Decimal-Value-as-a-Percentage-in-D365-BC.png?resize=768%2C424&amp;ssl=1 768w\" sizes=\"(max-width: 655px) 100vw, 655px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><a href=\"https:\/\/erpconsultors.com\/analyze-process-performance-in-business-central\/\" target=\"_blank\" rel=\"noreferrer noopener\">Analyze Process Performance in Business Central<\/a><br><a href=\"https:\/\/erpconsultors.com\/modify-d365-bc-server-services-using-bc-administration-shell\/\" target=\"_blank\" rel=\"noreferrer noopener\">Modify D365 BC Server Services Using BC Administration Shell<\/a><br><a href=\"https:\/\/erpconsultors.com\/attach-report-in-page-in-d365-bc\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to attach Report in Page in D365 BC<\/a><br><a href=\"https:\/\/erpconsultors.com\/define-custom-object-range-in-al-in-d365-bc\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to define Custom Object Range in AL in D365 BC<\/a><br><a href=\"https:\/\/erpconsultors.com\/usage-of-testfield-in-d365-bc\/\" target=\"_blank\" rel=\"noreferrer noopener\">Usage of TESTFIELD in D365 BC<\/a><br><a href=\"https:\/\/erpconsultors.com\/creation-and-usage-of-temporary-table-in-bc-d365\/\" target=\"_blank\" rel=\"noreferrer noopener\">Creation and Usage of Temporary Table in BC D365<\/a><br><a href=\"https:\/\/erpconsultors.com\/move-fields-in-page-via-al-extension-in-bc-d365\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Move fields in Page via AL Extension in D365 BC<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Display the Decimal Value as a Percentage in D365 BC: (1) In this blog we will get to know about the conversion of decimal values into percentages in D365 BC by using these properties: (2) For this create a field in the table, as shown. (3) After creating a field in the table, show that field on the page with these properties, as shown. (4) Notes from Microsoft: If you want to display the decimal value as a percentage, then you can add % at the end of the setting. For example: (5) After doing the above steps, publish the <\/p>\n","protected":false},"author":1,"featured_media":11276,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[1166,1167,1165],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2023\/04\/Display-the-Decimal-Value-as-a-Percentage-in-D365-BC.jpg?fit=500%2C250&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/11259"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=11259"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/11259\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/11276"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=11259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=11259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=11259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}