FunctionCall Class
A FunctionCall object represents a function call statement in an analytic calculation engine rule.
Use the following code to create a FunctionCall object:
&Assignment = create FunctionCall(&Constants.Function_Call_Type, [&Constants.]Function_Call_Name);
Where Function_Call_Type can be one of the following:
Value |
Description |
---|---|
FunctionCall_Type_Builtin |
Specifies that the function call is a PeopleSoft Analytic Calculation Engine built-in functions. In this instance, the function name must be prefaced with an already instantiated constants object. For the built-in function values used with Function_Call_Name, see below. |
FunctionCall_Type_UserFunc |
Specifies that the function call is a user function. The value specified for Function_Call_Name must be an already created user function defined in this analytic model. Specify this value as a string. |
When the Function_Call_Type is specified as Function_Call_Type_Builtin, the Function_Call_Name must be one of the following:
FunctionCall_Builtin_ABS
FunctionCall_Builtin_ACOS
FunctionCall_Builtin_ARGUMENTS
FunctionCall_Builtin_ASC
FunctionCall_Builtin_ASIN
FunctionCall_Builtin_AT
FunctionCall_Builtin_ATAN
FunctionCall_Builtin_BREAK
FunctionCall_Builtin_CASE
FunctionCall_Builtin_CHANGE
FunctionCall_Builtin_CHILDCOUNT
FunctionCall_Builtin_CHR
FunctionCall_Builtin_CONSOL
FunctionCall_Builtin_COS
FunctionCall_Builtin_CUBEID
FunctionCall_Builtin_CUBSUM
FunctionCall_Builtin_CUMAVG
FunctionCall_Builtin_DAVG
FunctionCall_Builtin_DAY
FunctionCall_Builtin_DCOUNT
FunctionCall_Builtin_DDB
FunctionCall_Builtin_DEC
FunctionCall_Builtin_DLOOKUP
FunctionCall_Builtin_DMAX
FunctionCall_Builtin_DMIN
FunctionCall_Builtin_DSUM
FunctionCall_Builtin_E
FunctionCall_Builtin_FIRST
FunctionCall_Builtin_FOR
FunctionCall_Builtin_FORCHILDREN
FunctionCall_Builtin_FORMEMBERS
FunctionCall_Builtin_FV
FunctionCall_Builtin_GROUPAVG
FunctionCall_Builtin_GROUPBY
FunctionCall_Builtin_GROUPMAX
FunctionCall_Builtin_GROUPMIN
FunctionCall_Builtin_GROUPSUM
FunctionCall_Builtin_GROW
FunctionCall_Builtin_IF
FunctionCall_Builtin_IFNPV
FunctionCall_Builtin_INC
FunctionCall_Builtin_INDICATE
FunctionCall_Builtin_INPUT
FunctionCall_Builtin_INSUBTREE
FunctionCall_Builtin_INTERCEPT
FunctionCall_Builtin_IRR
FunctionCall_Builtin_ISINPUT
FunctionCall_Builtin_LEFT
FunctionCall_Builtin_LEN
FunctionCall_Builtin_LN
FunctionCall_Builtin_LOWER
FunctionCall_Builtin_MATCH
FunctionCall_Builtin_MAX
FunctionCall_Builtin_MBR2TEXT
FunctionCall_Builtin_MEDIAN
FunctionCall_Builtin_MEMBER
FunctionCall_Builtin_MID
FunctionCall_Builtin_MIN
FunctionCall_Builtin_MOD
FunctionCall_Builtin_MONTH
FunctionCall_Builtin_NEXT
FunctionCall_Builtin_NPER
FunctionCall_Builtin_NUM2TEXT
FunctionCall_Builtin_NUMMEMBERS
FunctionCall_Builtin_NPV
FunctionCall_Builtin_PARAMETER
FunctionCall_Builtin_PARENT
FunctionCall_Builtin_PCT
FunctionCall_Builtin_PERCENTILE
FunctionCall_Builtin_PI
FunctionCall_Builtin_PMT
FunctionCall_Builtin_PREV
FunctionCall_Builtin_PREVSELF
FunctionCall_Builtin_PV
FunctionCall_Builtin_QUARTILE
FunctionCall_Builtin_RAND
FunctionCall_Builtin_RATE
FunctionCall_Builtin_REPLACE
FunctionCall_Builtin_RETURN
FunctionCall_Builtin_RIGHT
FunctionCall_Builtin_ROUND
FunctionCall_Builtin_SELF
FunctionCall_Builtin_SET
FunctionCall_Builtin_SIN
FunctionCall_Builtin_SLN
FunctionCall_Builtin_SLOPE
FunctionCall_Builtin_SQRT
FunctionCall_Builtin_STDEV
FunctionCall_Builtin_SYD
FunctionCall_Builtin_TAN
FunctionCall_Builtin_TEXT2MBR
FunctionCall_Builtin_TEXT2NUM
FunctionCall_Builtin_THIS
FunctionCall_Builtin_THISCUBE
FunctionCall_Builtin_TRUNC
FunctionCall_Builtin_UPPER
FunctionCall_Builtin_VAR
FunctionCall_Builtin_WHILE
FunctionCall_Builtin_YEAR
The following code creates a function call using a PeopleSoft Analytic Calculation Engine built-in function:
&FunCall = create FunctionCall(&Constants.FuncCall_Type_Builtin, &Constants.FuncCall_Builtin_ABS);