Formula Segments

The Formulas section on the Project Status Inquiry Column Definitions form provides Segment buttons that you use to select the columns to include in the formula. When you click the Segment button associated with the column type that you want to include in the equation, the system displays a list of columns of that type. You can then select the specific column to include in the equation. For example, when you click the Billing Amounts button, the system displays a list of the columns that are set up as billing amount columns.

You can select segments, and thus columns, for these column types:

• Ledger Types

• Non-JA Budget Amount Ledgers

• Non-JA Budget Unit Ledgers

• Billing Amounts

• Formulas

  See Formula Columns Within Another Formula Column.

In addition to the column types, the Formulas section includes a segment button for a Numeric Factor. When you click the Numeric Factor button, the system displays a field in which you enter the numeric factor to include in the formula. For example, if you want to divide a segment by a numeric factor, you could select the segment, select the division operator (/), and then click the Numeric Factor button to add the factor by which to divide the column amount in the first segment.

Note: If you use 0 (zero) as the denominator in a formula, the result of the formula will always be 0. For example, if you select a column named COST as your first segment, then select / (division) as the operator, and then use a numeric factor of 0 for the next segment, the formula would be: COST / 0. Because you specified to divide by 0, the result of the formula is 0. If you use a column with a 0 result in another column, the system uses 0 for the segment amount. For example, if you create a formula column that is A+B+(C/D) and the values for the columns are A=1000, B=1500, C=2000, and D=0, then the result is 2500 (1000+1500+(2000/0)). Because the system first solves the included formula (2000/0 = 0), the system adds 1000+1500+0 to return the result of 2500.

As you select segments, the system displays the column name or the column heading of the segment in the Formula Definition field. Select the Use Column Headings check box to view the column headings. Clear the Use Column Headings check box to view column names.