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);