Number formats

Revision as of 16:50, 26 August 2015 by DKontotasiou (talk | contribs)


Analytica User Guide >

The Number format dialog lets you control the format of numbers and dates displayed in tables, graphs, and input or output fields. You can select options like the number of decimal digits, currency signs, and commas to separate thousands. The default number format is suffix, which uses a letter following the number, such 10K to mean 10,000 (where K means Kilo or thousands).

The number format of a variable is used wherever the value of that variable appears —in a result table, graph, input field, or output field. The number format of an index applies wherever that index is used, including row or column headers of a table, or along an axis of a graph that uses that index.

You can enter a number into an expression or table in any format, no matter what output format it uses.

To set the number format for a variable:

  1. Select a variable by showing its edit table, result table, or graph, or by selecting its node in a diagram. To apply the same format to several variables, select their nodes together in a diagram.
  2. Select Number format from the Result menu, or press Control+b, to show this dialog.
    Chapter7 1.png
  3. Select the format type you want from the list on the left.
  4. Select options you want, such as Decimal digits, Show trailing zeroes, Thousands separators, or Show currency symbol, from checkboxes, menus, and fields on the right. The options available depend on which format you selected.
  5. View the example at the top of the dialog to see if the format is what you want.
  6. If so, click the Apply button.

You can change the default number format by pressing Set Default. The default format applies to all variables in your model whose number format has not been explicitly set.

Format types: Choose one of these number formats:

Chapter7 2.png

Suffix characters: Suffix is Analytica’s default format. It uses a conventional letter after each number to specify powers of 10: 12K means 12,000 (K for kilo or thousands), 2.5M means 2,500,000 (M for Mega or mil- lions), 5n means 0.000,000,005 (n means nano or billionths). Here are the suffix characters:

Chapter7 3.png

Tip
Note the difference between “M” for Mega or Million and “m” for milli (1/1000). This is the only situation in which Analytica cares about the difference between uppercase and lowercase. Otherwise, it is insensitive to case (except when matching text values).
Tip
In suffix format, it displays four-digit numbers without the “K” suffix — e.g., 2010, not 2.010K — which works better for years. For suffix, integer, or fixed point formats, it uses exponent format for numbers too large or small — e.g., numbers larger than 109 in integer or fixed point format, or larger than 1018 in suffix format.

Maximum precision: The maximum number of digits including decimal digits is 15 (14 for fixed point and percent); the maximum precision is 15 digits (9 for integers).

Number format options

Decimal digits: The number of digits to show after the decimal point.

Show trailing zeroes: Check to show trailing zeroes in decimals, e.g., 2.100 instead of 2.1, when decimal digits are set to 3.

Thousands separators: Check to show commas between every third digit of the integer part, e.g., 12,345.678, instead of 12345.678.

Show currency symbol: Check to show a currency symbol. Select the symbol and placement from these menus.

Chapter7 4.png

Placement controls the relative location of the currency symbol, e.g., $200 or 200DM, and whether to use a minus sign -$200 or parentheses ($200) to indicate a negative number.

Regional settings: If you select the last entry, regional, from the Symbol or Placement menu, it uses, respectively, the regional currency or placement settings set for your computer. You can modify these settings in the Regional and Language options available from the Windows Control Panel.

See Also

Chapter 7: Formatting Numbers, Tables, and Graphs <- Number formats -> Date formats
Comments


You are not allowed to post comments.