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:

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.
Copy link
On this page
Format types
Additional format options
How to access format options