{"id":1762,"date":"2021-11-08T10:02:08","date_gmt":"2021-11-08T01:02:08","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&p=1762"},"modified":"2021-11-08T10:02:08","modified_gmt":"2021-11-08T01:02:08","password":"","slug":"percentage-data-formatting","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/percentage-data-formatting\/","title":{"rendered":"Percentage data format"},"content":{"rendered":"

For reports using relative values, you can output the current data in text format with percentages. Consider the example of a report using relative values. Suppose you have a report that contains a list of products (standard format), prices (currency format), and a profitability index (number format).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now let's add a column showing profitability. In this case, profitability is a ratio expressed as a percentage. To do so, add a text component to the right with a reference to the Product.ProfitabilityIndex column and set the format of this text component to percent. The header for this column will be "Profitability".<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

There used to be two ways to determine the format mask.<\/p>\n\n\n\n

\"\"\u00a0Use local settings, the text is formatted according to the current settings of the operating system.<\/p>\n\n\n\n

\"\"\u00a0Each parameter is manually defined by the format mask.<\/p>\n\n\n\n

Both have their drawbacks. For example, if you change the format parameters in your local settings, you need to edit the OS format. In the second case, if one parameter needs to be changed, the other should also be adjusted. Considering the disadvantages of these methods, there is a third method for determining the format. You can change any parameter format using local settings. To do this, set a flag next to the parameter and set its value.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\"\"\u00a0 Group separator <\/strong><\/p>\n\n\n\n

Group separators separate currency values into numeric positions.<\/p>\n\n\n\n

\"\"\u00a0 Use local settings <\/strong><\/p>\n\n\n\n

If you use local settings, the numbers will be formatted for the currently installed OS.<\/p>\n\n\n\n

\"\"Number of digits after the decimal point<\/strong><\/p>\n\n\n\n

The number of digits after the decimal point, used for number formatting.<\/p>\n\n\n\n

\"\"\u00a0Decimal separator<\/strong><\/p>\n\n\n\n

Used as a decimal separator to separate numbers in formats.<\/p>\n\n\n\n

\"\"\u00a0Group separator<\/strong><\/p>\n\n\n\n

Used as a group separator when formatting numbers.<\/p>\n\n\n\n

\"\"\u00a0Group size<\/strong><\/p>\n\n\n\n

The number of digits in each group in the currency value format<\/p>\n\n\n\n

\"\"\u00a0Positive pattern<\/strong><\/strong><\/p>\n\n\n\n

This pattern is used to format positive values.<\/p>\n\n\n\n

\"\"\u00a0Negative pattern<\/strong><\/strong><\/p>\n\n\n\n

This pattern is used to format negative values.<\/p>\n\n\n\n

\"\"\u00a0percent sign<\/strong><\/strong><\/p>\n\n\n\n

This symbol is used as a percent sign.<\/p>","protected":false},"excerpt":{"rendered":"

\u76f8\u5bfe\u5024\u3092\u4f7f\u7528\u3057\u305f\u30ec\u30dd\u30fc\u30c8\u306e\u5834\u5408\u3001\u73fe\u5728\u306e\u30c7\u30fc\u30bf\u3092\u30d1\u30fc\u30bb\u30f3\u30c8\u8868\u793a\u306e\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u3067\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u76f8\u5bfe\u5024\u3092\u4f7f […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[74],"doc_tag":[],"class_list":["post-1762","docs","type-docs","status-publish","hentry","doc_category-text-formatting","entry"],"year_month":"2026-05","word_count":11,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"yuko.imai","author_nicename":"yuko-imai","author_url":"https:\/\/kintools.com\/en\/author\/yuko-imai\/"},"doc_category_info":[{"term_name":"\u30c6\u30ad\u30b9\u30c8\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8","term_url":"https:\/\/kintools.com\/en\/docs-category\/text-formatting\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=1762"}],"version-history":[{"count":1,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1762\/revisions"}],"predecessor-version":[{"id":1763,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1762\/revisions\/1763"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1762"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1762"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}