Formatting a variable

Change the appearance of a number by applying one of three number formats: Number, Currency and Percent and many other formatting options.

Applying number formats only affect the appearance of metrics and variables. They do not affect calculations.

Accessing format options

1. Hover the mouse over the variable

2. Click on Number format

3. Select the desired options

4. Click Save to apply the changes

List of formatting options

You can specify unit formats for your metrics and variables (such as K, M, etc.), decimal place precision, and how negative numbers, zeros and blanks and displayed.

This provides flexibility to visually distinguish the units of variables in your models (e.g. currencies, earnings multiples, ratios, time units etc).

Option	Description
Data type	Choose from Number (#), Percentage (%) or Currency ($) data types
Currency	Choose from any of 25 currencies on the list. Note: this option is shown only if Currency ($) option is chosen as the data type
Represent as	Choose from Full number, Thousands (K), Million (M) or Short number Full number: Displays the rounded up integer value. See examples below (value --> displayed number) • 1678.2 --> 1,678 • 321.91 --> 322 • 987654321.99786 --> 987,654,322 Thousands (K): Displays the rounded up value in thousands, appended with a 'K' at the end. See examples below (value --> displayed number) • 1678.2 --> 2K • 321 --> 0K • 1567980.19 --> 1,568K Millions (M): Displays the rounded up value in thousands, appended with an 'M' at the end. See examples below (value --> displayed number) • 88380 --> 0M • 588380.19 --> 1M • 50567980.19 --> 51M Short number: Drivetrain automatically chooses the best option from the above. See examples below (value --> displayed number) • 980.19 --> 980 • 1980.19 --> 2K • 901980.19 --> 902K • 1901980.19 --> 2M
Decimals	Define the number of digits to be included after the decimal between 0 and 4
Blank values	Choose between 0 (default option) or (blank) options to display blank or missing numbers. Note: (blank) option will not display a value on the cell
Zero values	Choose between 0 (default option) or - options
Negative values	Choose between (1234) (default option) or -1234 options