ANAPLAN MASTER ANAPLANNER COMPLETE
COURSE REVIEW GUIDE
◉ CUMULATE.
Answer: Gives the cumulative sum of values from the first period of
the timescale or the cumulative sum across the items in a named
non-time list.
◉ CURRENTPERIODEND.
Answer: The end date of the 'current period'.
◉ CURRENTPERIODSTART.
Answer: The start date of the 'current period'.
◉ CURRENTVERSION.
Answer: Returns the value of the current version as defined under
Settings, Versions.
◉ DATE.
Answer: Converts numbers yyyy, mm and dd to a date. Date format
depends on your locale.
,◉ DAY.
Answer: Converts a date to a day in number format. Date format
depends on your locale.
◉ DAYS.
Answer: Number of days in a time period.
◉ DAYSINMONTH.
Answer: Number of days in a specified calendar month.
◉ DAYSINYEAR.
Answer: Number of days in a specified year where year is formatted
as a four digit number, YYYY.
◉ DECUMULATE.
Answer: Calculates the difference in a value in the current period vs
previous period.
◉ DIVIDE.
Answer: Same as normal division x/y except that 1/0=Infinity and
0/0=NaN (not a number).
◉ END.
, Answer: Result is the last date in the period.
◉ ERLANG-B.
Answer: Assumes no queue and calculates the probability a call will
be blocked entirely.
◉ ERLANG-C.
Answer: Assumes an unlimited queue and calculates the probability
a call will be placed in the queue.
◉ EXP.
Answer: Returns e raised to the nth power, where e = 2.71828183.
◉ FIND.
Answer: Look for a text string within a text formatted item, starting
at a specified character number (result is a number that denotes the
character position).
◉ FINDITEM.
Answer: Matches text to an item of a list or matches text to a
member of a time period list (can match on item name or code).
◉ FIRSTNONBLANK.
COURSE REVIEW GUIDE
◉ CUMULATE.
Answer: Gives the cumulative sum of values from the first period of
the timescale or the cumulative sum across the items in a named
non-time list.
◉ CURRENTPERIODEND.
Answer: The end date of the 'current period'.
◉ CURRENTPERIODSTART.
Answer: The start date of the 'current period'.
◉ CURRENTVERSION.
Answer: Returns the value of the current version as defined under
Settings, Versions.
◉ DATE.
Answer: Converts numbers yyyy, mm and dd to a date. Date format
depends on your locale.
,◉ DAY.
Answer: Converts a date to a day in number format. Date format
depends on your locale.
◉ DAYS.
Answer: Number of days in a time period.
◉ DAYSINMONTH.
Answer: Number of days in a specified calendar month.
◉ DAYSINYEAR.
Answer: Number of days in a specified year where year is formatted
as a four digit number, YYYY.
◉ DECUMULATE.
Answer: Calculates the difference in a value in the current period vs
previous period.
◉ DIVIDE.
Answer: Same as normal division x/y except that 1/0=Infinity and
0/0=NaN (not a number).
◉ END.
, Answer: Result is the last date in the period.
◉ ERLANG-B.
Answer: Assumes no queue and calculates the probability a call will
be blocked entirely.
◉ ERLANG-C.
Answer: Assumes an unlimited queue and calculates the probability
a call will be placed in the queue.
◉ EXP.
Answer: Returns e raised to the nth power, where e = 2.71828183.
◉ FIND.
Answer: Look for a text string within a text formatted item, starting
at a specified character number (result is a number that denotes the
character position).
◉ FINDITEM.
Answer: Matches text to an item of a list or matches text to a
member of a time period list (can match on item name or code).
◉ FIRSTNONBLANK.
