A

B

C

D

E

F

H

I

L

M

N

O

P

Q

R

S

T

U

V

W

Y

Function	Description	Type
ABS	Returns the absolute value of a number.	Numeric
ADDMONTHS	Add a specified number of months to a date.	Time and Date
ADDYEARS	Add a specified number of years to a date.	Time and Date
AGENTS	Calculates the number of agents required to service a given number of calls and meet the service level agreement.	Call Center Planning
AGENTSB	Calculates the number of agents required to handle the busy-period call traffic, given a percentage of calls that might receive a busy tone.	Call Center Planning
x[ALL:y]	Flags where all items are populated with a check-mark (used with Boolean format).	Aggregation
AND	Enter several conditions and this function tests to see if all conditions are met.	Logical
ANSWERTIME	Calculates the minimum waiting time to maintain a service level agreement.	Call Center Planning
x[ANY:y]	Flags where any items are populated with a check-mark (used with Boolean format).	Aggregation
ARRIVALRATE	Calculates the arrival rate of calls that can be received while guaranteeing the service level agreement.	Call Center Planning
x[AVERAGE:y]	Calculates the average for a specified range of values.	Numeric
AVGDURATION	Calculates the average duration of calls that are answered while guaranteeing the service level agreement.	Call Center Planning
AVGWAIT	Calculates the average waiting time for incoming calls.	Call Center Planning
BLANK	When the result is text, list, time period, or date-formatted the result can be set to be BLANK.	Logical
CODE	Returns the code of a list item.	Miscellaneous
COLLECT	Collects the data from the original line items from one or more modules (module must have a line item subset as a dimension).	Miscellaneous
COMPARE	Compares text values; result is 0 if they match, 1 or -1 if not matched.	Logical
COUPDAYS	Returns the number of coupon days in the coupon period that contains the settlement date.	Financial
COUPDAYSBS	Calculates the number of coupon days before the settlement date.	Financial
COUPDAYSNC	Determines the number of coupon days from the settlement date until the next coupon date.	Financial
COUPNCD	Calculates the next coupon date after the settlement date.	Financial
COUPNUM	Returns the number of coupons payable between the settlement date of a bond and the bond's maturity.	Financial
COUPPCD	Identifies the previous coupon date before the settlement date.	Financial
CUMIPMT	Calculates the cumulative interest paid on a loan during a specified period.	Financial
CUMPRINC	Calculates the cumulative total of the principal amount paid during a given period for a loan.	Financial
CUMULATE	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.	Time and Date
CURRENTPERIODEND	The end date of the Current period.	Time and Date
CURRENTPERIODSTART	The start date of the Current period.	Time and Date
CURRENTVERSION	Returns the value of the current version as defined under Settings, Versions.	Miscellaneous
DATE	Converts numbers yyyy, mm, and dd to a date. Date format depends on your locale.	Time and Date
DAY	Converts a date to a day in number format. Date format depends on your locale.	Time and Date
DAYS	Number of days in a time period.	Time and Date
DAYSINMONTH	Number of days in a specified calendar month.	Time and Date
DAYSINYEAR	Number of days in a specified year where year is formatted as a four digit number, YYYY.	Time and Date
DECUMULATE	Calculates the difference in a value in the current period vs previous period.	Time and Date
DIVIDE	Same as normal division x/y except that 1/0=Infinity and 0/0=NaN (not a number).	Numeric
DURATION	Uses the Macaulay duration to indicate a bond price's response to changes in yield.	Financial
END	Result is the last date in the period.	Time and Date
ERLANG-B	Assumes no queue and calculates the probability a call will be blocked entirely.	Call Center Planning
ERLANG-C	Assumes an unlimited queue and calculates the probability a call will be placed in the queue.	Call Center Planning
EXP	Returns e raised to the nth power, where e = 2.71828183.	Numeric
FIND	Look for a text string within a text-formatted item, starting at a character number. Returns a number that denotes the character position.	Miscellaneous
FINDITEM	Matches text to a list item or matches text to an item in a time period list (can match on item name or code).	Miscellaneous
FIRSTNONBLANK	Shows the first non-blank text, list or date cell and uses the mapping to determine where to post the result.	Logical
FIRSTNONZERO	This takes at least two numeric arguments, and returns the first that is non-zero.	Numeric
FV	Future value of an investment.	Financial
HALFYEARTODATE	Takes a single numeric parameter and returns a cumulative sums across a half-year time span and then resets.	Time and Date
HALFYEARVALUE	Returns the half-year value of the source line item, according to the Time Summary method set for the source.	Time and Date
IF ISNOTBLANK	Test to see if a date, text, time period, or list-formatted cell is not blank.	Logical
IF ISBLANK	Tests whether a date, text, time period, or list-formatted cell is blank.	Logical
IF AND	Tests whether two or more conditions are met.	Logical
IF NOT	Tests whether condition is not true.	Logical
IF OR	Tests if any of two or more conditions is met.	Logical
IF THEN ELSE	Conditional formula.	Logical
INPERIOD	Tests whether a date falls within the period specified on the time dimension or falls within a time period (result is Boolean-formatted).	Time and Date
IPMT	Calculates the amount allocated to loan interest in a period.	Financial
IRR	Calculates the internal rate of return of a series of future cashflows.	Financial
ISACTUALVERSION	Tests to see if the version you are on is the Actual version (result is Boolean-formatted).	Logical
ISANCESTOR	Tests whether a specified list item is an ancestor of the second specified list item or whether a specified time period is an ancestor of a second specified time period (result is Boolean-formatted).	Logical
ISBLANK	Tests whether an item is blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted).	Logical
ISCURRENTVERSION	Tests to see if the version is current based on the flag that you have set in Settings > Versions.	Logical
ISFIRSTOCCURRENCE	Tests if a value in the source (first parameter) is the first occurrence of that value within the source (result is Boolean-formatted)	Logical
ISNOTBLANK	Tests whether an item is not blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted)	Logical
ITEM	Returns the list item of a list-formatted or time period-formatted line item.	Miscellaneous
LAG	Take the value from n periods in the past. If this is before the start of the timescale, use the overflow value.	Time and Date
LASTNONBLANK	Shows the last non-blank text, list or date cell and uses the mapping to determine where to post the result.	Logical
LEAD	Take the value from n periods in the future. If this is beyond the end of the timescale, use the overflow value.	Time and Date
LEFT	Extracts a sub-string from a string starting at the leftmost character.	Miscellaneous
LEN	Variant of LENGTH. Returns the number of characters in a text string.	Miscellaneous
LENGTH	Returns the number of characters in a text string.	Miscellaneous
LN	Returns the natural logarithm of a number, based on the constant e.	Numeric
LOG	Returns the logarithm of a number to the specified base.	Numeric
LOOKUP	Looks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.	Logical
LOWER	Converts text to lowercase.	Miscellaneous
MAILTO	Composes the To, cc, Bcc, Subject, and Body of an email.	Miscellaneous
MAKELINK	Composes a click-able URL.	Miscellaneous
MAX	Maximum value of selected line items.	Numeric
x[MAX:y]	The maximum value for a specified item in one of the target dimensions. The source will have a list-formatted item for this dimension.	Aggregation
MDURATION	Uses the modified Macaulay duration to tell you by what percentage the value of a bond will change for a 1% change in the yield.	Financial
MID	Extract a sub-string from a string starting at any character.	Miscellaneous
MIN	Minimum of selected line items.	Numeric
x[MIN:y]	The minimum value for a specified item in one of the target dimensions. The source will have a list-formatted item for this dimension.	Aggregation
MOD	Modulus: remainder after dividing a dividend by a divisor.	Numeric
MONTH	Converts a date or a time period to a calendar month as number.	Time and Date
MONTHTODATE	Takes a single numeric parameter and returns a cumulative sums across a month time span and then resets.	Time and Date
MONTHVALUE	Returns the month value of the source line item, according to the time summary method set for the source.	Time and Date
MOVINGSUM	Calculates moving values, such as a moving sum or moving average.	Time and Date
MROUND	Round to the nearest multiple.	Numeric
NAME	Converts a list item or time period to text.	Miscellaneous
NEXT	Returns a value from the next period.	Time and Date
NEXTVERSION	Returns a value from the next version.	Miscellaneous
NOT	Tests to see if a condition is not met (result is Boolean-formatted).	Logical
NPER	The length in periods of the investment term.	Financial
NPV	Calculates the net present value of a series of cash flows using a constant interest rate.	Financial
OFFSET	Returns a value from a specified number of periods in advance.	Time and Date
OR	Tests to see if any of two or more conditions is met.	Logical
PARENT	Can be used against list-formatted items to return the parent of a list item or against time period-formatted items to return the parent time period.	Miscellaneous
PERIOD	Take a date as parameter and returns a time period as result.	Time and Date
PMT	Calculates the payments for a loan or annuity with constant payments and a constant interest rate.	Financial
POST	Post a value to a specified number of periods in the future.	Time and Date
POWER	Raise a value to a power.	Numeric
PPMT	Calculates the amount of a payment allocated to the principal part of a loan.	Financial
PREVIOUS	Takes a value from the previous period.	Time and Date
PREVIOUSVERSION	Takes a value from the previous version.	Miscellaneous
PRICE	Returns the price per 100 monetary units of a bond that pays periodic interest.	Financial
PROFILE	Allocates a value over the next few periods based on a table.	Time and Date
PV	Calculates the present value of future cash flows.	Financial
QUARTERTODATE	Takes a single numeric parameter and returns a cumulative sums across a quarter time span and then resets.	Time and Date
QUARTERVALUE	Returns the quarter value of the source line item, according to the time summary method set for the source.	Time and Date
RANK	Orders a set of values and assigns rankings from 1 to a specified ending rank.	Miscellaneous
RANKCUMULATE	Allows you to cumulate line item values based on ranking criteria, that might contain groupings. Can be used against lists but not time.	Aggregation
RATE	Calculates a per period interest rate.	Miscellaneous
RIGHT	Extracts a sub-string from a string starting at the rightmost character.	Miscellaneous
ROUND	Rounds a value to a specified number of decimal places.	Numeric
SELECT	Selects a specific item from one or more of the hierarchy lists.	Logical
SELECT & LOOKUP	Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.	Compound
SIGN	Show the sign of a number (result = -1 if the value is negative, 1 if positive, 0 if zero).	Numeric
SLA	Calculates the percentage of incoming calls to be answered within a target answer time to meet a Service Level Agreement (SLA).	Call Center Planning
SPREAD	Spreads a value evenly over a number of periods.	Time and Date
SQRT	Square root of a value.	Numeric
START	Result is the first date in the period.	Time and Date
SUBSTITUTE	Replaces a single text character or a string of text characters with another.	Miscellaneous
SUM	Sums values based on a list-formatted or time period-formatted line item or property in the source that matches a dimension in the target.	Logical
SUM & LOOKUP	Sums based on a list-formatted line item or property in the source, then looks up a value from a source module using one or more mappings.	Compound
SUM & SELECT	Selects a specific item from one or more of the hierarchy lists, then sums values based on a list-formatted line item or property in the source that matches a dimension in the target.	Compound
TEXT	Converts a numeric value to text.	Miscellaneous
TEXTLIST	Lists a series of text items in a single result cell.	Aggregation
TIMESUM	Aggregates between the from and to time periods. These can be absolute time periods or relative to the latest actual time period.	Aggregation
TRIM	Replaces multiple text spaces between words in text, and at the beginning or end of the text, with a single space.	Miscellaneous
UPPER	Converts text to uppercase.	Miscellaneous
VALUE	Converts a numeric value in a text field to a number format.	Miscellaneous
WEEKDAY	Takes a date and returns a number 1 to 7 for the day-of-week number. An optional Type parameter can be used to set the start day for the day-of-week count.	Time and Date
WEEKTODATE	Takes a single numeric parameter and returns a cumulative sums across a week time span and then resets.	Time and Date
WEEKVALUE	Returns the week value of the source line item, according to the time summary method set for the source.	Time and Date
YEAR	Converts a date or a time period to a year in number format.	Time and Date
YEARFRAC	Calculates the fraction of a year between two dates.	Financial
YEARTODATE	Takes a single numeric parameter and returns a cumulative sums across a year time span and then resets.	Time and Date
YEARVALUE	Returns the year value of the source line item, according to the time summary method set for the source.	Time and Date
YIELD	Determines the yield to maturity of a bond — the interest rate that, when used to discount the bond's future cashflows, produces the given price.	Financial

Argument	Data type	Description
Number	Number	The number to determine the sign of.

Formula	Result
`SIGN(100)`	1
`SIGN(0)`	0
`SIGN(-10)`	-1

Arguments

Excel equivalent

Examples