Table/Matrix: Flexible Handling of Decimals by Adding Field Formatting-Display Units: Percentage option

Issue: Currently, the user can define the display format for decimal number (original format) into percentage using Format = Percentage and selecting the desired decimal places. This multiplies the column value in decimal form by 100 and appends a percentage sign (e.g., 0.35254 --> 35.254%). It is then applied across all visuals with the specified decimal places (e.g. 4). So, the user has only the option to either display decimal values (0.35254) OR percentage values with a percent sign (35.254%) with specified decimal places.

The problem is the user may want to be able to display the value in percentage format without the percentage sign (e.g., 35.254) and with different number of decimal places depending on the visual. This would be required to either save space and/or increase/decrease the precision of the displayed format in the visual.

1. In a report, you want to display the values in a table/matrix column without the percentage sign (%) to save space (column header can add "%" label) and with fewer decimal places (e.g., 0.35254 --> 35.3)

The current workaround is to calculate a new calculated column that multiples the original column by 100. Then, the user can either drop the decimal or multiplied version on the report and format using the current functionality. This takes up more space and requires creating 2 versions of each measure.

Enhancement Request: Add a new "Display units" option for "Percentage" in the Field Formatting dropdown for tables/matrix which multiplies the selected field by 100. This is analogous to the current options that basically divide by factors of 10.

If there is another way to achieve this then please let me know.

Thanks