Technical data
Creating Rules, Formul as, and User Functions Chapter 10
1. Perform one of these actions:
• To define a new user func tion, select Part, New, User Function.
The Edit Part Name dialog box appears. Enter the name for the user function and click OK.
• To edit an existing user function, select the user function whose formula you want to edit.
2. Click inside the rule bar.
3. Enter a new rule or edit the existing rule.
See C
hapter 10,
“Creating Rules, Formulas, and U ser Functions,” Working with the Elements of
Rules, page 120.
4. Perform one of t
hese actions:
• Click the Accep
t Changes button to accept the changes.
• Click the Exit F
ormula Mode button to keep the changes without validating the formula.
• Click the Cance
l Changes button to cancel the changes.
Working with the Elements of Rules
This section p
rovides an overview of the elements of rules and discusses how to:
• Insert a built-in function into a rule.
• Insert a user function into a rule.
• Insert a numeric value or text value into a rule.
• Insert a data cube reference into a rule.
• Insert a dimension reference into a rule.
• Insert a dimension member reference into a rule.
• Insert a blank line into a rule.
• Insert a comment into a rule.
Understandin
g the Elem ents of Rules
This section discusses the various elements that are included in rules.
Built-in Functions
There are many
useful calculations that are difficult or impossible to perform with simple arithmetic. You can
perform many s
uch calculations by using PeopleSoft Analytic Calculation Engine’s built-in functions.
Most functions have one or more arguments that supply the information that the function needs to perform the
calculation. Arguments are enclosed within parentheses after a function name.
When a function contains more than one argument, the arguments are always separated by commas. For
example, the following formula uses the MIN function to calculate the minimum of CASH_NEEDED and
CREDIT_AVAILABLE to determine the values of the CASH_ADVANCE data cube:
MIN(CASH_NEEDED, CREDIT_AVAILABLE)
120 Copyright © 1988-2007, Oracl e. All rights reserved.