Instalaciones de electrólisis CHLORINSITU ® III Compact y IV Compact

Define a formula measure when you want to create a formula such as a sum, a ratio, and so forth for purposes of data analysis. Also define a formula measure when you want to view or manipulate data without impacting storage and system

performance.

Measures

◗◗ To define a formula measure:

1. Open the Demand Planning Administration page for the plan that you want to work with.

2. In the navigation list, choose Measures.

Result: The frame for maintaining measures opens. Existing measures appear in the grid.

3. Choose New.

Result: The Create Measure dialog box opens.

4. In the Create Measure dialog box, choose Formula Measure.

Result: The New Formula Measure dialog box opens.

5. In the name boxes, enter a short name and a long name for the measure.

The short name can be up to 16 characters long. The long name can be up to 70 characters long.

6. In the Type box, select the measure type. You can select one of the following:

■ Change — Calculates the change in a measure’s value between the current time period and a previous time period. You select the measure on which to base the calculation and specify a time period. This can be a custom time period, the prior time period, or year ago.

■ Fiscal-Year-to-Date — Sums the value of a measure through the fiscal year to date. You select the measure on which to base the calculation.

■ Lag — Calculates a measure that lags for a specified time period. You select the measure on which to base the lag and the lag interval.

■ Lead — Calculates a measure that leads for a specified time period. You select the measure on which to base the lead and the lead time period.

■ Moving Average — Averages the values of a measure over time. You select the measure on which to base the average and specify the number of time periods.

■ Moving Maximum — Finds the maximum value for a measure within a specified time period. You select the measure and specify the number of periods to consider.

■ Moving Minimum — Finds the minimum value for a measure within a specified time period. You select the measure and specify the number of

Measures

■ Moving Total — Sums the values of a measure over time. You select the measure and specify the number of time periods to consider.

■ Percent Change — Calculates the percentage change in a measure’s value between the current time period and a previous time period. You select the measure on which to base the calculation and specify a time period.

■ Year-to-Date — Sums up a measure’s values through the current calendar year. You select the measure on which to base the calculation.

■ Difference — Subtracts the value of one measure from another. You select the measures.

■ Multiplication — Multiplies the value of a measure by a numeric literal.

You select the measure and enter the multiplier.

■ Ratio — Divides the values of one measure by another. You select the measures.

■ Sum — Adds the value of a measure and a numeric literal. You select the measure and enter the value to add.

■ Index — Calculates the ratio between a specified dimension value of a measure and the same measure in a comparison or reference dimension.

You select the measure, the dimension value, and the reference dimension.

■ Nested — Performs simple nested formula calculations. These formulas take the form (A ? B) ? (C ? D), where you can replace each letter with a measure and each question mark with an arithmetic operator. You select the measures and specify the operators.

■ Share — Compares a measure’s value to the same measure’s value for a specified share reference point, such as a level or another product and displays the results as a percentage. You select the measure and the reference value.

■ Variance — Calculates the difference between the value of the measure for one dimension value and the value of the same measure for another dimension value. You select the measure and the dimension values.

Result: The components of the Definition box change depending on the type of measure that you chose.

7. Complete the other fields in the Definition box. The information that you provide depends on the measure type.

Measures

8. To specify an additional calculation to include in the formula, proceed as follows:

a. In the Additional Calculations box, select an operator and enter a number.

b. To specify that calculated values be positive, check Absolute Value.

9. To specify format attributes for the data associated with this measure, click Format.

Result: The Format Number dialog box opens, where you can specify the following format options:

■ Number of decimal places

■ How positive and negative values will display

■ Whether to use the thousands separator

■ Whether to display leading zeros

■ Whether to apply a currency or percentage symbol, the symbol to use, and how positive and negative values for currency or percent will display 10. If the Format Number dialog box is open, click OK to close it. The current

format selections will apply when you create the measure.

Result: You are returned to the New Formula Measure dialog box.

11. Click OK to create the measure.

Result: You are returned to the frame for maintaining measures frame. Your new measure now appears in the grid that shows current measure definitions.

Measures