HP 3000 Manuals

Table Calc Item Screen [ HP ALLBASE/BRW Reference Manual ] MPE/iX 5.0 Documentation

HP ALLBASE/BRW Reference Manual

Table Calc Item Screen

Use this screen to define a table calculated item.

To add a new item

1. Type the name of the Item, Result Type, Result Length, and Numeric
Result Precision.

2. Choose Add Item.

To copy an item

1. Type the name of the new item and press Clear Display.

2. Choose Add Item.

3. When you see the prompt, type the name of the item from which you
want to copy and optional Table Name if the item is in another
table. For a layout calculated item, type >LAYOUT in the Table
Name field.

4. Press Enter.

The item and its formulas are copied.

To modify an item

1. Use Next/Prev Item key to access the item you want to modify. You
can also use QUICK BROWSE to access an item. See Chapter 1
for details about the QUICK BROWSE feature.

2. Make the required changes to the item.

3. Press Enter.

To delete an item

1. Use Next/Prev Item key to access the item you want to delete. You
can also use QUICK BROWSE to access an item. See Chapter 1
for details about the QUICK BROWSE feature.

2. Choose Delete Item.

3. Press Enter or choose Delete Item to confirm the deletion.

The item and its formula are deleted.

To rename an item

1. Use Next/Prev Item key to access the it em you want to rename.
You can also use QUICK BROWSE to access an item. See Chapter 1
for details about the QUICK BROWSE feature.

2. Type the new name over the old item name.

3. Make any required changes to the item's definition and press
Enter.

4. Press Enter to confirm the rename.

Field Descriptions

Item

The name of the calculated item.

Result Type

One of the codes listed for the Result Type.

Result Length

Type the result length of the string. Maximum is 255; minimum is 1.
Required only if this item is a string.

Numeric Result Precision

Type a number and method code for the numeric precision of the calculated
item, if you want precision to be changed at this stage of the report.

------------------------------------------------------------------------------------------
| |
| Valid range for Numeric (type N): -6 through 12; |
| |
| for Integer (type (I): 0 through 8; |
| |
| for Real (type R): -90 through 76. |
| |
------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------
| |
| Method Codes: Digits are: |
| |
-------------------------------------------------------------------------------------------
| |
| R rounded |
| |
| T truncated |
| |
| C ceiled |
| |
-------------------------------------------------------------------------------------------

This is illustrated in the following examples:

If calculation with this the result with
results in: numeric precision: changed precision is:

--------------------------------------------------------------------------------------

1024.3849 -2R 1024.38

864186.46 3C 865000.00

See the description of Real Numbers in Chapter 4 for a description of
Real output forms and precision.

MPE/iX 5.0 Documentation