Multiple formats in one table

Analytica User GuideNumber and table formatsMultiple formats in one table

You can change the number format for a subset of cells in a table by selecting those cells and then bringing up the Number Format Dialog. This is intuitive, but it is often easier and preferable for your table to infer the number formats for each slice from the number formats of its parent variables. This happens if you define the result as a list of variables, for example:

Index Years := 2007..2012

Variable DollarX := Table(Years)(...) { Formatted as dollars }

Variable PercentX := DollarX/40K { Formatted as percent }

Variable MultiformatX := [DollarX, PercentX]

MultiformatX →

This table uses the number format set for each variable responsible for a row here — as long as you don’t override their settings by setting a format for MultiformatX.

See Also

• Number formats
• Creating Arrays (Tables)
• Tutorial: Arrays
• Table
• Slice
• Numbers and text
• Datatype functions
• Cell format dialog
• MultiTables

Display of constraint resultsMultiple formats in one tableGraphs