Anaplan Functions: Complete Study Set (100% Correct)

Anaplan Functions: Complete Study Set (100% Correct)

ABS Right Ans - FUNCTION(#)

Returns the absolute value of a number. The absolute value of zero or a
positive number remains the same. The absolute value of a negative number is
the same number without the negative sign (the positive version).

ADDMONTHS Right Ans - FUNCTION(Date, number)

Function adds a number of months to a date.

ADDYEARS Right Ans - FUNCTION(Date, number)

Adds a number of years to a date.

AGENTS Right Ans - FUNCTION(SLA, Target response time, Arrival rate,
Average duration)

Calculates the number of servers (or agents) needed to fulfil requests within a
target time.

AGENTSB Right Ans - FUNCTION(SLA, Arrival rate, Average duration)

calculates the number of servers required to answer a specified percentage of
calls (or SLA) within a busy period.

ALL Right Ans - Source[FUNCTION: Mapping, FUNCTION: Mapping 2, etc.]

Returns a TRUE result for all values that match specific Boolean criteria in a
source module.

ANSWERTIME Right Ans - FUNCTION(Number of servers, SLA, Arrival rate,
Average duration)

Calculates the minimum hold time required to answer a certain percentage of
calls, or service level agreement (SLA).

ANY Right Ans - Source[FUNCTION: Mapping, FUNCTION: Mapping 2, etc.]

,Returns a TRUE result for any value that matches specific Boolean criteria in a
source module.

ARRIVALRATE Right Ans - FUNCTION(Number of servers, SLA, Target
response time, Average duration)

Calculates the maximum interval between requests possible while processing
a specified percentage of these requests.

AVERAGE Right Ans - Values to average[FUNCTION: Mapping, FUNCTION:
Mapping 2, etc.]

Takes a set of values from a source module and returns the mean average in a
result module.

AVGDURATION Right Ans - FUNCTION(Number of servers, SLA, Target
response time, Arrival rate)

Calculates the required average duration of calls in order to answer a certain
percentage of calls, or service level agreement (SLA).

AVGWAIT Right Ans - FUNCTION(Number of servers, Arrival rate, Average
duration)

Calculates the average waiting time for a request or call to be processed.

CODE Right Ans - FUNCTION(ITEM)

returns a list item's code.

COLLECT Right Ans - FUNCTION ()

Use the function in a module that includes a line item subset to pull the source
line item values into the module.

COMPARE Right Ans - FUNCTION(Text to compare 1, Text to compare 2 [,
Comparison mode] [, Locale])

, compares text values. If they're the same, it returns 0. If the first text value is
greater, it returns 1, and if the first text value is less, it returns -1.

COUPDAYBS Right Ans - FUNCTION(Settlement, Maturity, Frequency[,
Basis])

calculate the number of days from the beginning of the coupon period until its
settlement date. The number returned includes both the first day of the period
and the settlement date.

COUPDAYS Right Ans - FUNCTION(Settlement, Maturity, Frequency[,
basis])

return the number of coupon days in the coupon period that contains the
settlement date.

COUPDAYSNC Right Ans - FUNCTION(Settlement, Maturity, Frequency[,
basis])

calculate the number of coupon days from the settlement date until the next
coupon date. The number returned excludes the settlement date and includes
the last day of the next coupon period.

COUPNCD Right Ans - FUNCTION(Settlement, Maturity, Frequency)

calculates the next coupon date after a settlement date.

COUPNUM Right Ans - FUNCTION(Settlement, Maturity, Frequency)

returns the number of coupons payable between a settlement and maturity
date.

COUPPCD Right Ans - FUNCTION(Settlement, Maturity, Frequency)

calculates the previous coupon date before a settlement date.

CUMIPMT Right Ans - FUNCTION(Interest rate, Number of periods,
Principal, Start period, End period [, Timing])