Links

Formatting variables

Format types

All variables have one of five available formats: Number, Date, Currency, Percent and Boolean.
Number
Date
Currency
Percent
Boolean
For quantities that aren't percentages or currencies. If a quantity can only be a whole number, turn the Integer toggle on.
The number will be formatted as a date. You can enter the date as date(yyyy,mm,dd) or as date(yyyy,mm).
Specify the currency symbol using the input box. Will default to the last used currency symbol
This expects the variable's value to be a decimal. Example: 0.5 will be displayed as 50%. You can also enter directly as "50%".
A variable that can be True or False (1 or 0). Boolean variables will be displayed with a checkbox:

Custom unit formatting

You can also set custom unit formats for your variables, and set whether that unit is displayed before or after the number (prefix vs. suffix).
This gives you ultimate flexibility to visually distinguish the units of variables in your models (e.g. currencies, earnings multiples, ratios, time units etc). Note that custom units are purely visual and do not affect calculations whatsoever.

Additional format options

Precision
Human-readable
Negatives
Commas
Magnitude
Empty value
Automatic, or specify the number of decimal places or significant figures.
1,000 -> 1k, 1,000,000 -> 1m, etc. Human readable is automatically on.
Accounting negatives i.e. ($100,000) not -$100,000
Red negatives i.e. -$100,000
or both ($100,000)
Comma separators, i.e. 1000 -> 1,000, 10000 -> 10,000, etc. Comma separators are automatically on.
Automatic (as entered), or specify the 'unit' (thousand, lakh, million, crore, billion, trillion) you want to display the value in. For example, if you entered 100 but format the display as 'thousand', this will be 0.1k.
Lets you define how an empty value of a variable will be treated: as 0 (default) or as None. This affects how averages are calculated. See None values for more.

How to access format options

  1. 1.
    Right click a variable/s -> Format (or use the keyboard shortcuts); or
2. Hit the Format icon on a variable.
Tip: to edit the format of multiple variables at once by multi-selecting the variables (cmd/ctrl + click, or shift+↑/↓), then doing either of the above.

Changing the currency symbol for the entire model

To change the currency symbol for the entire model, multi-select (cmd/ctrl + click) all the relevant variables, then hit the format icon on one of the variables, and change the symbol.