Difference between revisions of "Number format"
(rewrite)
Line 2: Line 2:
 
[[What's new in Analytica 4.0?]] >
 
[[What's new in Analytica 4.0?]] >
  
−
You can use the Number format dialog to set format for numbers in tables, graphs, and input and output nodes. If you set the number format for an Index, for example, it will use that format for that index in every graph or table that uses that index.
+
[Number formats are expanded in Release 4.0, notably multiple currency signs and date formats.]
 +
 
 +
The '''Number Format''' dialog box lets you control the format of numbers in result tables and graphs — including dates and Booleans, and 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). See below for details.
 +
 
 +
The number format of a variable applies wherever the value of that variable appears — in a result table, graph, input or output field. The number format for 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.
  
 
To set the number format for a variable:
 
To set the number format for a variable:
−
# Select its node in a diagram, or display its result or edit table window. (You can also set number format for several variables, if you select their nodes.)
+
# Select a variable by showing its Edit table, result table or graph, or by selecting its node in a diagram. Select multiple nodes if you want to apply the same format to multiple variables.
−
# Select '''Number format...''' from the '''Result''' menu, or press ''control-b'', to open the Number format dialog.
+
# Open the '''Number format''' dialog in either of these ways:
 +
** Select '''Number format...''' from the '''Result''' menu, or
 +
** Press ''control-b''
 
# Select the option you want from the Formats list.
 
# Select the option you want from the Formats list.
 
# Select options such as Decimal digits, Show trailing zeroes, or Thousands separators depending on what you want and what's available. See below for details.
 
# Select options such as Decimal digits, Show trailing zeroes, or Thousands separators depending on what you want and what's available. See below for details.
Line 12: Line 18:
 
# If so, click '''Apply''' button.
 
# If so, click '''Apply''' button.
  
 +
[[Image:Fixed_point_currency.png]]
  
−
For details on date formats see [[Date Functions]]
+
'''Decimal digits:''' The number of digits to show after the decimal point.
  
−
[[Image:Number format.png]]
+
'''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.
  
−
Fixed Point (Currency checked)
+
'''Thousands separators:''' Show commas between every third digit -- e.g. 1,234.567,890, instead of 1234.567890
−
 
 
−
[[Image:Fixed_point_currency.png]]
 
−
 
 
−
Currency symbol pulldown
 
  
 +
'''Show currency symbol:''' Display the selected currency symbol.
 +
* '''Symbol:''' If you select the last entry, "$ (regional)", it uses the currency symbol set for your computer in the '''Regional and Language options''', available from Windows '''Control Panel'''. In this case, the symbol may vary depending on the settings of the computer running the model.
 
[[Image:Symbol.png]]
 
[[Image:Symbol.png]]
  
−
 
+
* Placement: Select the format for currency symbol and negative numbers. It lets you position the currency symbol before or after the number,  e.g. $200 or 200DM; to use negative sign -$200, or parentheses, ($200), to indicate a negative number; and the relative placement of negative and currency symbols. The final option "regional" uses the placement settings from the ''Regional and Language options''', available from Windows '''Control Panel'''.
−
Currency symbol pulldown
 
  
 
[[Image:Placement.png]]
 
[[Image:Placement.png]]
  
−
Date format, custom selected
+
===Date format===
  
 
[[Image:Custom_date.png]]
 
[[Image:Custom_date.png]]
  
−
[Expanded in release 4.0]
+
For details on date formats see [[Date Functions]]

Revision as of 16:52, 24 August 2007

What's new in Analytica 4.0? >

[Number formats are expanded in Release 4.0, notably multiple currency signs and date formats.]

The Number Format dialog box lets you control the format of numbers in result tables and graphs — including dates and Booleans, and 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). See below for details.

The number format of a variable applies wherever the value of that variable appears — in a result table, graph, input or output field. The number format for 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.

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. Select multiple nodes if you want to apply the same format to multiple variables.
  2. Open the Number format dialog in either of these ways:
    • Select Number format... from the Result menu, or
    • Press control-b
  1. Select the option you want from the Formats list.
  2. Select options such as Decimal digits, Show trailing zeroes, or Thousands separators depending on what you want and what's available. See below for details.
  3. Check the example at the top of the dialog to see if it's what you want.
  4. If so, click Apply button.

Fixed point currency.png

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: Show commas between every third digit -- e.g. 1,234.567,890, instead of 1234.567890

Show currency symbol: Display the selected currency symbol.

  • Symbol: If you select the last entry, "$ (regional)", it uses the currency symbol set for your computer in the Regional and Language options, available from Windows Control Panel. In this case, the symbol may vary depending on the settings of the computer running the model.

Symbol.png

  • Placement: Select the format for currency symbol and negative numbers. It lets you position the currency symbol before or after the number, e.g. $200 or 200DM; to use negative sign -$200, or parentheses, ($200), to indicate a negative number; and the relative placement of negative and currency symbols. The final option "regional" uses the placement settings from the Regional and Language options', available from Windows Control Panel.

Placement.png

Date format

Custom date.png

For details on date formats see Date Functions

Comments


You are not allowed to post comments.