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 from which you can 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)

See Defining a total name.

  1. Access Compute Statement (RW50.1).
  2. Define a compute statement. Specify this information:
    Compute

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

    Compute Description
    Provide a description of the compute statement.
    Folder

    Specify or select the folder 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. This list shows the valid operation symbols:

    • + for addition
    • - for subtraction
    • * for multiplication
    • / for division
    • ** for exponents
    • ABS for absolute values
    Take note of these 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 an operation symbol counts as one element.
    Select Usage, list

    Select the applications where you use the compute statement.

    You can use Compute Listing (RW250) to list all compute statements.