EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37307: How to change a Metric's values to be displayed as ratio instead of number in MicroStrategy 10.x?


Stefan Zepeda

Salesforce Solutions Architect • Strategy


KB37307: How to change a Metric's values to be displayed as ratio instead of number in MicroStrategy 10.x?

If a metric is defined as (FactA/ FactB) or (MetricA/MetricB), then by default it will be displayed as number in the report. How can the display format of this metric be changed such that it will be displayed as ratio?
 
 
The following procedure describes how to achieve this in Strategy 10.x:
 
In order for a metric to be displayed as ratio, its Number Formatting has to be changed to "Fraction". Inside a metric editor, go to Tools -> Formatting -> Values and from the Number tab, select the Category as Fraction as shown in the following screenshot:
 

ka02R000000kYAeQAM_0EM440000002DcI.jpeg

  
 
The metric is defined as / and its number formatting has been set as Fraction. When this metric is used on the report, it will be displayed as Ratio as shown below:
 

ka02R000000kYAeQAM_0EM440000002DcW.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017