Change the Way Numbers Are Displayed in a Case Table

Top  Previous  Next

How To... > Work with Case Tables > Change the Way Numbers Are Displayed in a Case Table

You can control the way numbers are displayed in case tables, determining the number of decimal places shown or formatting numbers in scientific or engineering notation.

 

1.Select the attribute whose number format you want to change by clicking on its name in a case table.
2.Choose Table | Number Format.

formatvalue

 

3.Choose the option that you want and click OK.

Dynamic

The default numeric format, Dynamic, is a good general-purpose format. It displays up to six significant digits with a decimal point, unless the number is too big or too small, in which case it displays scientific notation with six significant digits. It doesn’t display trailing zeroes after the decimal point.

Fixed Decimal

All numbers will have the same number of digits after the decimal point, the number specified in the Decimal Places field.

Scientific Notation

A number expressed in scientific notation has one digit to the left of the decimal point, as many digits as are specified in the Significant Digits field, and an exponent that specifies by what power of 10 to multiply.

Engineering Notation

In engineering notation, the number of digits to the left of the decimal point is either one, two, or three, adjusted so that the power of 10 will always be a multiple of 3.

This table gives some examples, all with six digits specified in the Number Format dialog box.

_img101

 

Date and Time Formatting

DateTime values can be formatted to honor different date and time formats. There are 3 drop down menus that let you format the date and the time separately and determine in what order they are displayed.

The table below gives some examples of date time formats.

dtformattbl