Creating a compute statement

Use this procedure to define a compute statement. A compute statement is an arithmetic equation consisting of Lawson data dictionary names, total names, and operation symbols that enable you to create customized calculation formulas.

If you are using a total name in your compute statement, then you must first define a total name on Total Names (RW70.1) Defining a total name

To create a compute statement, complete these steps:

  1. Access Compute Statement (RW50.1).
  2. Define a compute statement. Use these guidelines to specify the field values:
    Compute, Compute Description

    Specify or select the name and description of the compute statement that you are defining.

    Folder

    Specify or select the folder where you want to store the compute statement.

    Compute Line

    Specify the calculation formula for the compute statement. Compute statements are arithmetic equations consisting of data dictionary names and operation symbols. These are the valid operation symbols:

    • + for addition

    • - for subtraction

    • * for multiplication

    • / for division

    • ** for exponents

    • ABS for absolute values

    These are the considerations before constructing a compute statement:

    1. Data dictionary items are given parameters such as periods, column numbers, budget numbers, total names, and accounting unit overrides.

    2. You can use parentheses to determine the order of operations within arithmetic equations.

    3. You can define a maximum combination of 40 numbers and data dictionary items for each formula. For example, the compute statement (CPBUD*CPAMT) / 100 is equivalent to three. Any item preceding or following an operation symbol counts as one element.

    Select Usage, list

    Select which applications where you will use the compute statement.

Related reports and inquiries

To Use
List all compute statements. Compute Listing (RW250)