How to Display the Decimal Value as a Percentage in D365 BC

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:

• AutoFormatType.
• AutoFormatExpression.

(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:

• AutoFormatType = 10;
• AutoFormatExpression = ‘<precision, 1:1><standard format,0>%’
• 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%.
• For more information refer to this link- Setting the AutoFormatExpression property.

(5) After doing the above steps, publish the extension and check the result, as shown.

• Enter 0.234 in the field “Decimal value as Percentage” and the system auto convert it into 23.40%, as shown