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

KB9709: How to format metric values of 1,100,000 into a 1.1 million type format using custom formatting in MicroStrategy Developer 9.4.x-10.x?


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This knowledge base article outlines the process of formatting metric values of 1,100,000 into a 1.1 million type format using custom formatting in MicroStrategy Developer 9.4.x-10.x.

In addition to the the pre-defined options for metric formatting, Strategy supports custom formatting.
The Strategy Tutorial project is used to explain how users can customize numbers from "1,000,000" to a "1.00" format.
Consider a report containing row data values greater than a million, as illustrated below:

ka02R000000kcOOQAY_0EM440000002FzO.jpeg

To format these metric values to use a decimal (i.e., 1.1) instead of showing all the numerals, right-click on the metric ('Revenue' , for this example) and select Formatting > Revenue Values, as shown below:

ka02R000000kcOOQAY_0EM440000002FzN.jpeg

Select "Custom" as a category in the Number tab and enter '0,,.##' (without quotation marks), as shown below:

ka02R000000kcOOQAY_0EM440000002FzQ.jpeg

Confirm that the format applied properly:

ka02R000000kcOOQAY_0EM440000002FzP.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

April 28, 2017

Last Updated:

April 28, 2017