EXCEL function | Excel Description | ANAPLAN Solution |
ABS | Returns the absolute value of a number | ABS—Returns the absolute value of a number. |
ACCRINT | Returns the accrued interest for a security that pays interest on a periodic basis | |
ACCRINTM | Returns the accrued interest for a security that pays interest at maturity | |
ACOS | Returns the arccosine (in radians) of a number | No native Anaplan function |
ACOSH | Returns the inverse hyperbolic cosine of a number | No native Anaplan function |
ADDRESS | Returns a text representation of a cell address | NAME |
AGGREGATE | Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows | Anaplan aggregates as part of the module functionality, set the aggregation level in the module |
AMORDEGRC | Returns the linear depreciation of an asset for each accounting period, on a prorated basis | |
AMORLINC | Returns the depreciation of an asset for each accounting period, on a prorated basis | |
x[ALL:y] | AND | Returns TRUE if all conditions are TRUE |
AREAS | Returns the number of ranges in a reference | No native Anaplan function |
ASIN | Returns the arcsine (in radians) of a number | No native Anaplan function |
ASINH | Returns the inverse hyperbolic sine of a number | No native Anaplan function |
ATAN | Returns the arctangent (in radians) of a number | No native Anaplan function |
ATAN2 | Returns the arctangent (in radians) of (x,y) coordinates | No native Anaplan function |
ATANH | Returns the inverse hyperbolic tangent of a number | No native Anaplan function |
AVEDEV | Returns the average of the absolute deviations of the numbers provided | No native Anaplan function: can be built using calculation |
AVERAGE | Returns the average of the numbers provided | x[AVERAGE:y] |
AVERAGEA | Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0 |
No native Anaplan function |
AVERAGEIF | Returns the average of all numbers in a range of cells, based on a given criteria | x[AVERAGE:y]—calculates the average for a specified range of values. |
AVERAGEIFS | Returns the average of all numbers in a range of cells, based on multiple criteria | x[AVERAGE:y]—calculates the average for a specified range of values. |
BETA.DIST | Returns the beta distribution | No native Anaplan function |
BETA.INV | Returns the inverse of the cumulative beta probability density function | No native Anaplan function |
BETADIST | Returns the cumulative beta probability density function | No native Anaplan function |
BETAINV | Returns the inverse of the cumulative beta probability density function | No native Anaplan function: can be built using calculation |
BIN2DEC | Converts a binary number to a decimal number | No native Anaplan function: can be built using calculation |
BIN2HEX | Converts a binary number to a hexadecimal number | No native Anaplan function: can be built using calculation |
BIN2OCT | Converts a binary number to an octal number | No native Anaplan function: can be built using calculation |
BINOM.DIST | Returns the individual term binomial distribution probability | No native Anaplan function: can be built using calculation |
BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion | No native Anaplan function: can be built using calculation |
BINOMDIST | Returns the individual term binomial distribution probability | No native Anaplan function: can be built using calculation |
CEILING | Returns a number rounded up based on a multiple of significance | MROUND—round to the nearest desired multiple. |
CEILING.PRECISE | Returns a number rounded up to the nearest integer or to the nearest multiple of significance | MROUND—round to the nearest desired multiple. |
CELL | Used to retrieve information about a cell such as contents, formatting, size, etc. |
No native Anaplan function |
CHAR | Returns the character based on the ASCII value | No native Anaplan function. |
CHIDIST | Returns the one-tailed probability of the chi-squared distribution | No native Anaplan function: can be built using calculation |
CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution | No native Anaplan function: can be built using calculation |
CHITEST | Returns the value from the chi-squared distribution | No native Anaplan function: can be built using calculation |
CHOOSE | Returns a value from a list of values based on a given position | FINDITEM—matches text to an item in a list or matches text to an item in a time period list (can match on item name or code). |
CLEAN | Removes all non-printable characters from a string |
No native Anaplan function |
CODE | Returns the ASCII value of a character or the first character in a cell | CODE—enter several conditions and the AND function tests to see if all conditions are met. |
COLUMN | Returns the column number of a cell reference | ITEM. |
COLUMNS | Returns the number of columns in a cell reference | No native Anaplan function: can be built using calculation |
COMBIN | Returns the number of combinations for a specified number of items | No native Anaplan function: can be built using calculation |
COMBINA | Returns the number of combinations for a specified number of items and includes repetitions | No native Anaplan function: can be built using calculation |
COMPLEX | Converts coefficients (real and imaginary) into a complex number | No native Anaplan function: can be built using calculation |
CONCAT | Used to join two or more strings together | &—concatenates two or more text strings. |
CONCATENATE | Used to join two or more strings together (replaced by CONCAT Function) | &—concatenates two or more text strings. |
CONCATENATE with & | Used to join two or more strings together using the & operator | &—concatenates two or more text strings. |
CONVERT | Convert a number from one measurement unit to another measurement unit | 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. |
COS | Returns the cosine of an angle | No native Anaplan function: can be built using calculation |
COSH | Returns the hyperbolic cosine of a number | No native Anaplan function: can be built using calculation |
COUNT | Counts the number of cells that contain numbers as well as the number of arguments that contain numbers | Use an IF THEN statement with a SUM function to accomplish the same goals. Use IF THEN ELSE to create a count, then use SUM to get the total for that line item. |
COUNTA | Counts the number of cells that are not empty as well as the number of value arguments provided | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
COUNTBLANK | Counts the number of empty cells in a range | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
COUNTIF | Counts the number of cells in a range, that meets a given criteria | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
COUNTIFS | Counts the number of cells in a range, that meets a single or multiple criteria | You can combine an IF THEN statement with a SUM function to accomplish the same goals. |
COUPDAYBS | Returns the number of days from the beginning of a coupon period until its settlement date | COUPDAYBS |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date | COUPDAYS |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date | COUPDAYSNC |
COUPNCD | Returns a number that represents the next coupon date after the settlement date | COUPNCD |
COUPNUM | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon | COUPNUM |
COUPPCD | Returns a number that represents the previous coupon date before the settlement date | COUPPCD |
COVAR | Returns the covariance, the average of the products of deviations for two data sets | No native Anaplan function: can be built using calculation |
DATE | Returns the serial date value for a date | DATE—converts numbers yyyy, mm and dd to a date. Date format depends on your locale. |
DATEDIF | Returns the difference between two date values, based on the interval specified | DECUMULATE—calculates the difference in a value in the current period vs previous period. |
DATEVALUE | Returns the serial number of a date |
Function not required by Anaplan—use Date Settings. |
DAVERAGE | Averages all numbers in a column in a list or database, based on a given criteria |
Function not required by Anaplan—use Summary method AVERAGE. |
DAY | Returns the day of the month (a number from 1 to 31) given a date value | DAY—converts a date to a day in number format. Date format depends on your locale. |
DAYS | Returns the number of days between two dates | DAYS—number of days in a time period. Takes no parameter or a single time period parameter. Returns the number of days in a time period: |
DAYS360 | Returns the number of days between two dates based on a 360-day year | DAYS—number of days in a time period. Takes no parameter or a single time period parameter. Returns the number of days in a time period: |
DB | Returns the depreciation of an asset based on the fixed-declining balance method | See Financial Functions |
DCOUNT | Returns the number of cells in a column or database that contains numeric values and meets a given criteria | Function not required by Anaplan—use SUM |
DCOUNTA | Returns the number of cells in a column or database that contains non-blank values and meets a given criteria | Function not required by Anaplan—use SUM |
DDB | Returns the depreciation of an asset based on the double-declining balance method | |
DEGREES | Converts radians into degrees | No native Anaplan function: can be built using calculation |
DGET | Retrieves from a database a single record that matches a given criteria | ITEM |
DMAX | Returns the largest number in a column in a list or database, based on a given criteria | x[MAX:y] |
DMIN | Returns the smallest number in a column in a list or database, based on a given criteria | x[MIN:y] |
DOLLAR | Converts a number to text, using a currency format | No native Anaplan function: can be built using calculation |
DPRODUCT | Returns the product of the numbers in a column in a list or database, based on a given criteria |
No native Anaplan function: can be built using calculation |
DSTDEV | Returns the standard deviation of a population based on a sample of numbers |
No native Anaplan function: can be built using calculation |
DSTDEVP | Returns the standard deviation of a population based on the entire population of numbers |
No native Anaplan function: can be built using calculation |
DSUM | Sums the numbers in a column or database that meets a given criteria | |
DURATION | Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield | DURATION |
DVAR | Returns the variance of a population based on a sample of numbers |
Using SELECT and COLLECT with line items to calculate Variance |
DVARP | Returns the variance of a population based on the entire population of numbers |
Using SELECT and COLLECT with line items to calculate Variance |
EDATE | Adds a specified number of months to a date and returns the result as a serial date | OFFSET—returns a value from a specified number of periods in advance |
EOMONTH | Calculates the last day of the month after adding a specified number of months to a date | END |
ERROR.TYPE | Returns the numeric representation of an Excel error |
No native Anaplan function: can be built using calculation. |
EVEN | Rounds a number up to the nearest even integer | No native Anaplan function: can be built using calculation |
EXACT | Compares two strings and returns TRUE if both values are the same | COMPARE—compares text values; result is 0 if they match, 1 or -1 if not matched. |
EXP | Returns e raised to the nth power | EXP—returns e raised to the nth power. |
FACT | Returns the factorial of a number | No native Anaplan function: can be built using calculation. |
FALSE | Returns a logical value of FALSE |
Anaplan Functionality: Boolean argument |
FIND | Returns the location of a substring in a string (case-sensitive) | FIND—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). |
FIXED | Returns a text representation of a number rounded to a specified number of decimal places | VALUE—converts a numeric value in a text field to a number format. |
FLOOR | Returns a number rounded down based on a multiple of significance | No native Anaplan function: can be built using calculation |
FORECAST | Returns a prediction of a future value based on existing values provided | FV |
FREQUENCY | Returns how often values occur within a set of data. It returns a vertical array of numbers |
No native Anaplan function: can be built using calculation |
FV | Returns the future value of an investment | FV |
GROWTH | Returns the predicted exponential growth based on existing values provided | EXP distributed along timeline |
HLOOKUP | Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number | 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. |
HOUR | Returns the hours (a number from 0 to 23) from a time value | No native Anaplan function: can be built using calculation |
HYPERLINK | Creates a shortcut to a file or Internet address | MAKELINK—composes a click-able URL |
IF | Returns one value if the condition is TRUE or another value if the condition is FALSE | IF THEN ELSE—conditional formula |
IF (more than 7) | Nest more than seven IF functions | IF THEN ELSE—conditional formula |
IF (up to 7) | Nest up to seven IF functions | IF THEN ELSE—conditional formula |
IFERROR | Used to return an alternate value if a formula results in an error | IF THEN ELSE |
IFNA | Used to return an alternate value if a formula results in #N/A error | IF THEN ELSE |
IFS | Specify multiple IF conditions within a function | IF THEN ELSE |
INDEX | Returns either the value or the reference to a value from a table or range | FINDITEM—matches text to an item in a list or matches text to an item in a time period list (can match on item name or code) |
INDIRECT | Returns the reference to a cell based on its string representation | Use LOOKUP and TEXT |
INFO | Returns information about the operating environment |
No native Anaplan function: can be built using calculation |
INT | Returns the integer portion of a number | Handled by module formatting. |
INTERCEPT | Returns the y-axis intersection point of a line using x-axis values and y-axis values |
No native Anaplan function: can be built using calculation |
IPMT | Returns the interest payment for an investment | RATE—calculates a per period interest rate |
IRR | Returns the internal rate of return for a series of cash flows | IRR |
ISBLANK | Used to check for blank or null values | ISBLANK—tests whether an item is blank |
ISERR | Used to check for error values except #N/A | No native Anaplan function: can be built using calculation |
ISERROR | Used to check for error values | No native Anaplan function: can be built using calculation |
ISLOGICAL | Used to check for a logical value (TRUE or FALSE) | No native Anaplan function: can be built using calculation |
ISNA | Used to check for #N/A error | No native Anaplan function: can be built using calculation |
ISNONTEXT | Used to check for a value that is not text | No native Anaplan function: can be built using calculation |
ISNUMBER | Used to check for a numeric value | No native Anaplan function: can be built using calculation |
ISOWEEKNUM | Returns the ISO week number for a date |
No native Anaplan function—Use the internal time structure within Anaplan |
ISPMT | Returns the interest payment for an investment | RATE—calculates a per period interest rate. |
ISREF | Used to check for a reference | No native Anaplan function: can be built using calculation |
ISTEXT | Used to check for a text value | No native Anaplan function: can be built using calculation |
LARGE | Returns the nth largest value from a set of values |
No native Anaplan function: can be built using calculation |
LEFT | Extract a substring from a string, starting from the left-most character | LEFT—extracts a substring from a string starting at the leftmost character |
LEN | Returns the length of the specified string | LEN—variant of LENGTH. Returns the number of characters in a text string |
LINEST | Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line |
No native Anaplan function: can be built using calculation |
LN | Returns the natural logarithm of a number | LN—returns the natural logarithm of a number, based on the constant e |
LOG | Returns the logarithm of a number to a specified base | LOG—returns the logarithm of a number to the specified base |
LOG10 | Returns the base-10 logarithm of a number | LOG—returns the logarithm of a number to the specified base |
LOOKUP | Returns a value from a range (one row or one column) or from an array | 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. |
LOWER | Converts all letters in the specified string to lowercase | LOWER—converts text to lowercase |
MATCH | Searches for a value in an array and returns the relative position of that item | 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. |
MAX | Returns the largest value from the numbers provided | MAX |
MAXA | Returns the largest value from the values provided (numbers, text and logical values) | x[MAX_y] |
MDETERM | Returns the matrix determinant of an array | No native Anaplan function: can be built using calculation |
MDURATION | Returns the modified Macauley duration for a security with an assumed par value of $100 | MDURATION |
MEDIAN | Returns the median of the numbers provided |
No native Anaplan function: can be built using calculation |
MID | Extracts a substring from a string (starting at any position) | MID—extract a substring from a string starting at any character |
MIN | Returns the smallest value from the numbers provided | MIN—minimum of selected line items |
MINA | Returns the smallest value from the values provided (numbers, text and logical values) | MIN—minimum of selected line items |
MINUTE | Returns the minutes (a number from 0 to 59) from a time value |
No native Anaplan function: can be built using calculation |
MINVERSE | Returns the inverse matrix for a given matrix | No native Anaplan function: can be built using calculation |
MIRR | Returns the modified internal rate of return for a series of cash flows | IRR |
MMULT | Returns the matrix product of two arrays | No native Anaplan function: can be built using calculation |
MOD | Returns the remainder after a number is divided by a divisor | Modulus: remainder after dividing a dividend by a divisor |
MONTH | Returns the month (a number from 1 to 12) given a date value | MONTH—converts a date or a time period to a calendar month as number |
N | Converts a value to a number | VALUE |
NA | Returns the #N/A error value |
No native Anaplan function |
NETWORKDAYS | Returns the number of work days between two dates, excluding weekends and holidays |
Function not supported by Anaplan: can be built using calculation |
NETWORKDAYS.INTL | Returns the number of work days between two dates, excluding weekends and holidays |
Function supported by Anaplan in Settings |
NOT | Returns the reversed logical value | NOT |
NOW | Returns the current system date and time | No native Anaplan function: can be built by creating a module called Today with one date-formatted line item which is selected when required |
NPER | Returns the number of periods for an investment | NPER |
NPV | Returns the net present value of an investment | NPV |
ODD | Rounds a number up to the nearest odd integer | No native Anaplan function: can be built using ROUND calculation |
OFFSET | Returns a reference to a range that is offset a number of rows and columns | No native Anaplan function: can be built using calculation |
OR | Returns TRUE if any of the conditions are TRUE | x[ANY_y] |
PERCENTILE | Returns the nth percentile from a set of values |
No native Anaplan function: can be built using calculation |
PERCENTRANK | returns the rank of a value in a set of values as a percentage of the set |
No native Anaplan function: can be built using calculation: Percentile = (number of values below X) + 0.5)/total number of values*100
|
PERMUT | Returns the number of permutations for a specified number of items |
For permutations where repetition is allowed, use POWER, with the number of items as x and the number of permutations as n. |
PI | Returns the mathematical constant called pi | No native Anaplan function: can be built using calculation |
PMT | Returns the payment amount for a loan | PMT—Take a date as parameter and returns a time period as result |
POWER | Returns the result of a number raised to a given power | POWER—Raise a value to a power |
PPMT | Returns the payment on the principal for a particular payment | |
PRICE | Returns the price per $100 face value of a security that pays periodic interest | PRICE |
PRODUCT | Multiplies the numbers and returns the product | Using a intermediate line item with the Summary as PRODUCT |
PROPER | Sets the first character in each word to uppercase and the rest to lowercase | None: can be achieved through Formula |
PV | Returns the present value of an investment | PV—calculates the present value of future cash-flows |
QUARTILE | Returns the quartile from a set of values |
No native Anaplan function: can be built using calculation |
RADIANS | Converts degrees into radians | No native Anaplan function: can be built using calculation |
RAND | Returns a random number that is greater than or equal to 0 and less than 1 | No native Anaplan function: can be built using calculation |
RANDBETWEEN | Returns a random number that is between a bottom and top range | No native Anaplan function: can be built using calculation |
RANK | Returns the rank of a number within a set of numbers | RANK—orders a set of values and assigns rankings from 1 to a specified ending rank |
RATE | Returns the interest rate for an annuity | RATE—calculates a per period interest rate |
REPLACE | Replaces a sequence of characters in a string with another set of characters | Use FIND, LEN, LEFT, RIGHT,& |
REPT | Returns a repeated text value a specified number of times | No native Anaplan function: can be built using calculation |
RIGHT | Extracts a substring from a string starting from the right-most character | RIGHT—extracts a substring from a string starting at the rightmost character |
ROMAN | Converts a number to roman numeral | No native Anaplan function: can be built using calculation |
ROUND | Returns a number rounded to a specified number of digits | ROUND |
ROUNDDOWN | Returns a number rounded down to a specified number of digits | ROUND |
ROUNDUP | Returns a number rounded up to a specified number of digits | ROUND |
ROW | Returns the row number of a cell reference | ITEM |
ROWS | Returns the number of rows in a cell reference | No native Anaplan function: can be built using calculation |
SEARCH | Returns the location of a substring in a string | FIND—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). |
SECOND | Returns the seconds (a number from 0 to 59) from a time value | No native Anaplan function: can be built using calculation |
SIGN | Returns the sign of a number | SIGN—show the sign of a number (result = -1 if the value is negative, 1 if positive, 0 if zero) |
SIN | Returns the sine of an angle | No native Anaplan function: can be built using calculation |
SINH | Returns the hyperbolic sine of a number | No native Anaplan function: can be built using calculation |
SLN | Returns the depreciation of an asset based on the straight-line depreciation method | SPREAD |
SLOPE | Returns the slope of a regression line based on the data points identified by known_y_values and known_x_values |
No native Anaplan function: can be built using calculation |
SMALL | Returns the nth smallest value from a set of values |
No native Anaplan function: can be built using calculation |
SQRT | Returns the square root of a number | SQRT—square root of a value |
STDEV | Returns the standard deviation of a population based on a sample of numbers |
No native Anaplan function: can be built using calculation |
STDEVA | Returns the standard deviation of a population based on a sample of numbers, text, and logical values |
No native Anaplan function: can be built using calculation |
STDEVP | Returns the standard deviation of a population based on an entire population of numbers |
No native Anaplan function: can be built using calculation |
STDEVPA | Returns the standard deviation of a population based on an entire population of numbers, text, and logical values |
No native Anaplan function: can be built using calculation |
SUBSTITUTE | Replaces a set of characters with another | Use FIND, LEN, & |
SUBTOTAL | Returns the subtotal of the numbers in a column in a list or database | SUM & SELECT—first it selects a specific item from one or more of the hierarchy lists, then it sums values based on a list-formatted line item or property in the source that matches a dimension in the target. |
SUM | Adds all numbers in a range of cells | 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. |
SUMIF | Adds all numbers in a range of cells based on one criteria | Create intermediate module—configure Rows as criteria, column as line item which SUM criteria |
SUMIFS | Adds all numbers in a range of cells, based on a single or multiple criteria | Create intermediate module—configure Rows as criteria, column as line item which SUM criteria |
SUMPRODUCT | Multiplies the corresponding items in the arrays and returns the sum of the results |
No native Anaplan function: can be built using calculation |
SUMSQ | Returns the sum of the squares of a series of values | Use POWER with SUM. |
SUMX2MY2 | Returns the sum of the difference of squares between two arrays | No native Anaplan function: can be built using calculation |
SUMX2PY2 | Returns the sum of the squares of corresponding items in the arrays | No native Anaplan function: can be built using calculation |
SUMXMY2 | Returns the sum of the squares of the differences between corresponding items in the arrays | No native Anaplan function: can be built using calculation |
SYD | Returns the depreciation of an asset based on the sum-of-years' digits depreciation method |
No native Anaplan function: can be built using calculation |
T | Returns the text referred to by a value | TEXT—converts a numeric value to text. |
TAN | Returns the tangent of an angle | No native Anaplan function: can be built using calculation |
TANH | Returns the hyperbolic tangent of a number | No native Anaplan function: can be built using calculation |
TEXT | Returns a value converted to text with a specified format | TEXT—converts a numeric value to text |
TEXTJOIN | Used to join two or more strings together separated by a delimiter |
&—concatenates two or more text strings |
TIME | Returns a decimal number given an hour, minute and second value | No native Anaplan function: can be built using calculation |
TIMEVALUE | Returns the serial number of a time | No native Anaplan function: can be built using calculation |
TODAY | Returns the current system date | No native Anaplan function: can be built using calculation |
TRANSPOSE | Returns a transposed range of cells | Create a new module with pivoted view |
TRIM | Returns a text value with the leading and trailing spaces removed | Use LEN, LEFT, RIGHT |
TRUE | Returns a logical value of TRUE |
Anaplan functionality: Boolean argument |
TRUNC | Returns a number truncated to a specified number of digits | Handled by module formatting |
TYPE | Returns the type of a value |
No native Anaplan function |
UPPER | Convert text to all uppercase | UPPER—converts text to uppercase |
VALUE | Converts a text value that represents a number to a number | VALUE—converts a numeric value in a text field to a number format |
VAR | Returns the variance of a population based on a sample of numbers | Using SELECT and COLLECT with line items to calculate Variance |
VARA | Returns the variance of a population based on a sample of numbers, text, and logical values | Using SELECT and COLLECT with line items to calculate Variance |
VARP | Returns the variance of a population based on an entire population of numbers | Using SELECT and COLLECT with line items to calculate Variance |
VARPA | Returns the variance of a population based on an entire population of numbers, text, and logical values | Using SELECT and COLLECT with line items to calculate Variance |
VDB | Returns the depreciation of an asset based on a variable declining balance depreciation method | |
VLOOKUP | Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position | 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. |
WEEKDAY | Returns a number representing the day of the week, given a date value | 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. |
WEEKNUM | Returns the week number for a date |
No native Anaplan function. Use the internal time structure within Anaplan: can be built using calculation. |
WORKDAY | Adds a specified number of work days to a date and returns the result as a serial date |
No native Anaplan function. Use the internal time structure within Anaplan: can be built using calculation. |
WORKDAY.INTL | Adds a specified number of work days to a date and returns the result as a serial date (customizable weekends) |
No native Anaplan function. Use the internal time structure within Anaplan—can be built using calculation. |
XIRR | Returns the internal rate of return for a series of cash flows that may not be periodic | |
YEAR | Returns a four-digit year (a number from 1900 to 9999) given a date value | YEAR—converts a date or a time period to a year in number format. |
YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date) | YEARFRAC |
YIELD | Returns the yield on a security that pays periodic interest | YIELD |
Some of the functions available in Excel are directly comparable with Anaplan Functions.