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

KB17533: How to create a round down metric in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


How to create a round down metric in MicroStrategy Developer 9.x

To create a round-down function that produces the following sample results, use the following formula in Metric Editor in Strategy Developer 9.x:
 
24.45 -> 24.4
 
24.41 -> 24.4
 
See below for the definition of the metric:
 

ka02R000000kWy3QAE_0EM440000002F2o.jpeg

 
The image below describes the difference between normal metric and round-down metric.
 

ka02R000000kWy3QAE_0EM440000002F2j.jpeg

 
Formula:
 
(Int((Revenue * 10)) / 10)


Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

April 13, 2017