| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | function | name | syntax | summary | params | link | ||||||||||||||||||||
2 | ABS | abs | ABS(x) | Returns the absolute value of a number. | x: Number. | https://community.anaplan.com/anapedia/calculation-functions/abs | ||||||||||||||||||||
3 | ADDMONTHS | addmonths | ADDMONTHS(x, n) | Add a specified number of months to a date. Result is 12/25/2011 when x is 06/25/2011 and n is 6. Date format depends on your locale. | x: Date,n: Number: No of months to add | https://community.anaplan.com/anapedia/calculation-functions/addmonths | ||||||||||||||||||||
4 | ADDYEARS | addyears | ADDYEARS(x, n) | Add a specified number of years to a date. | x: Date,n: Number: No of years to add | https://community.anaplan.com/anapedia/calculation-functions/addyears | ||||||||||||||||||||
5 | AGENTS | agents | AGENTS(w, t, y, z) | Calculates the number of agents required to service a given number of calls and meet the service level agreement. | w: The service level agreement or the percentage of calls to be answered in the target answer time,t: the target answer time,y: The arrival rate of calls or number of calls per unit of time,z: the average call duration. | https://community.anaplan.com/anapedia/calculation-functions/agents | ||||||||||||||||||||
6 | AGENTSB | agentsb | AGENTSB(w, y, z) | Calculates the number of agents required to handle the busy-period call traffic, given a percentage of calls that might receive a busy tone. | w: the service level agreement, which is defined as the percentage of calls that do not get blocked,y: the arrival rate of calls or number of calls per unit of time for the designated busy period,z: the average call duration during the designated busy period. | https://community.anaplan.com/anapedia/calculation-functions/agentsb | ||||||||||||||||||||
7 | AND | and | AND(x, y, z) | Enter several conditions and the AND function tests to see if all conditions are met. | x: Boolean or an expression that equates to a Boolean result,y: Boolean or an expression that equates to a Boolean result,z: Boolean or an expression that equates to a Boolean result | https://community.anaplan.com/anapedia/calculation-functions/and | ||||||||||||||||||||
8 | x[ALL:y] | x[all:y] | x[ALL:y] | Flags where all members are populated with a checkmark (used with Boolean format). | x : Boolean formatted source line item,y : list formatted source line item that uses a list matched to a result dimension. | https://community.anaplan.com/anapedia/calculation-functions/x[all:y] | ||||||||||||||||||||
9 | x[ANY:y] | x[any:y] | x[ANY:y] | Flags where any members are populated with a checkmark (used with Boolean format). | x : Boolean formatted source line item,y : list formatted source line item that uses a list matched to a result dimension. | https://community.anaplan.com/anapedia/calculation-functions/x[any:y] | ||||||||||||||||||||
10 | ANSWERTIME | answertime | ANSWERTIME(x, w, y, z) | Calculates the minimum waiting time for which the service level agreement can be maintained. | x: number of servers, telephone lines, or agents,w: service level agreement or the percentage of calls to be answered within the target answer time,y: arrival rate of calls or the number of calls per unit of time,z: average call duration. | https://community.anaplan.com/anapedia/calculation-functions/answertime | ||||||||||||||||||||
11 | ARRIVALRATE | arrivalrate | ARRIVALRATE(x, w, t, z) | Calculates the arrival rate of calls that can be received while guaranteeing the service level agreement. | x: number of servers, telephone lines, or agents,w: service level agreement of the percentage of calls to be answered within the target answer time,t: target answer time,z: average call duration. | https://community.anaplan.com/anapedia/calculation-functions/arrivalrate | ||||||||||||||||||||
12 | x[AVERAGE:y] | x[average:y] | x[AVERAGE: y] | Calculates the average for a specified range of values. | x: Number,y: ListItem, Time Period. | https://community.anaplan.com/anapedia/calculation-functions/x[average:y] | ||||||||||||||||||||
13 | AVGDURATION | avgduration | AVGDURATION(x, w, t, y) | Calculates the average duration of calls that are answered while guaranteeing the service level agreement. | x: number of servers, telephone lines, or agents,w: service level agreement of the percentage of calls to be answered within the target answer time,t: target answer time,y: arrival rate of calls or the number of calls per unit of time. | https://community.anaplan.com/anapedia/calculation-functions/avgduration | ||||||||||||||||||||
14 | AVGWAIT | avgwait | AVGWAIT(x, y, z) | Calculates the average waiting time for incoming calls. | x: number of servers, telephone lines, or agents,y: arrival rate of calls or the number of calls per unit of time,z: average call duration. | https://community.anaplan.com/anapedia/calculation-functions/avgwait | ||||||||||||||||||||
15 | BLANK | blank | IF (y) THEN (x) ELSE BLANK | When the result of a conditional arguments is text, list, time period, or date formatted the result can be set to be BLANK. | y: The test condition,x: A text, list, time period, or date result.) | https://community.anaplan.com/anapedia/calculation-functions/blank | ||||||||||||||||||||
16 | CODE | code | CODE(list item) | Returns the code of a list item. | https://community.anaplan.com/anapedia/calculation-functions/code | |||||||||||||||||||||
17 | COLLECT | collect | COLLECT() | The function collects the original line item values from the source module or modules that you selected for your line item subset. | No Parameters - The function works with the line item subset | https://community.anaplan.com/anapedia/calculation-functions/collect | ||||||||||||||||||||
18 | COMPARE | compare | COMPARE(x, y) | Compares text values; result is 0 if they match, 1 or -1 if not matched. | x and y are text expressions | https://community.anaplan.com/anapedia/calculation-functions/compare | ||||||||||||||||||||
19 | CUMULATE | cumulate | CUMULATE(x, [y], [z]) | 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. | x: the numeric line item source whose values are cumulatively summed,y: [opt] flag to control a reset of the cumulative progression,z: [opt] used to designate the list cumulated against. | https://community.anaplan.com/anapedia/calculation-functions/cumulate | ||||||||||||||||||||
20 | CURRENTPERIODEND | currentperiodend | CURRENTPERIODEND() | The end date of the 'current period' of the Timescale on the Settings tab | No Parameters | https://community.anaplan.com/anapedia/calculation-functions/currentperiodend | ||||||||||||||||||||
21 | CURRENTPERIODSTART | currentperiodstart | CURRENTPERIODSTART() | The start date of the 'current period'. | No Parameters | https://community.anaplan.com/anapedia/calculation-functions/currentperiodstart | ||||||||||||||||||||
22 | CURRENTVERSION | currentversion | CURRENTVERSION(x) | Returns the value of the current version as defined under Settings, Versions. | x : Number, Boolean, date, time period, list, or text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/currentversion | ||||||||||||||||||||
23 | DATE | date | DATE(yyyy,mm,dd) | Converts numbers yyyy, mm and dd to a date. Date format depends on your locale. | yyyy - Year,mm - Month,dd - date | https://community.anaplan.com/anapedia/calculation-functions/date | ||||||||||||||||||||
24 | DAY | day | DAY(x) | Converts a date to a day in number format. Date format depends on your locale. | x: Number | https://community.anaplan.com/anapedia/calculation-functions/day | ||||||||||||||||||||
25 | DAYS | days | DAYS([x]) | Number of days in a time period. | 1) No parameter. Returns the number of days with reference to the source module time dimension,2) Time period parameter (Month Period). Returns the number of days in the time period,3) Hard-coded (TIME.'Jan 17'). Returns the number of days with reference to the source timescale setting. | https://community.anaplan.com/anapedia/calculation-functions/days | ||||||||||||||||||||
26 | DAYSINMONTH | daysinmonth | DAYSINMONTH(yyyy,mm) | Number of days in a specified calendar month. | yyyy - Year,mm - Month | https://community.anaplan.com/anapedia/calculation-functions/daysinmonth | ||||||||||||||||||||
27 | DAYSINYEAR | daysinyear | DAYSINYEAR(yyyy) | Number of days in a specified year where year is formatted as a four digit number, YYYY. | yyyy - Year | https://community.anaplan.com/anapedia/calculation-functions/daysinyear | ||||||||||||||||||||
28 | DECUMULATE | decumulate | DECUMULATE(x) | Calculates the difference in a value in the current period vs previous period. | x: line item to compare | https://community.anaplan.com/anapedia/calculation-functions/decumulate | ||||||||||||||||||||
29 | DIVIDE | divide | DIVIDE(x,y) | Same as normal division x/y except that 1/0=Infinity and 0/0=NaN (not a number). | x: Number,y: Number | https://community.anaplan.com/anapedia/calculation-functions/divide | ||||||||||||||||||||
30 | END | end | END([x]) | Result is the last date in the period. | 1) END(),2) END(x) where x: Timeperiod,3) END(Time.'Period') argument is hardcoded | https://community.anaplan.com/anapedia/calculation-functions/end | ||||||||||||||||||||
31 | ERLANG-B | erlang-b | ERLANGB(x, y, z) | Assumes no queue and calculates the probability a call will be blocked entirely. | x: number of servers, telephone lines, or agents,y: arrival rate of calls or the number of calls per unit of time,z: average call duration. | https://community.anaplan.com/anapedia/calculation-functions/erlang-b | ||||||||||||||||||||
32 | ERLANG-C | erlang-c | ERLANGC(x, y, z) | Assumes an unlimited queue and calculates the probability a call will be placed in the queue. | x: number of servers, telephone lines, or agents,y: arrival rate of calls or the number of calls per unit of time,z: average call duration. | https://community.anaplan.com/anapedia/calculation-functions/erlang-c | ||||||||||||||||||||
33 | EXP | exp | EXP(x) | Returns e raised to the nth power, where e = 2.71828183. | x: Number | https://community.anaplan.com/anapedia/calculation-functions/exp | ||||||||||||||||||||
34 | FIND | find | FIND(x,y,[n]) | 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). | x :text-formatted cell containing the text you want to find,y: text formatted cell containing the text to search ,n: [opt] The character at which to start the search. The first character is 1. | https://community.anaplan.com/anapedia/calculation-functions/find | ||||||||||||||||||||
35 | FINDITEM | finditem | FINDITEM(x,y) | Finds a valid item in a list or time period list by matching a text string or code to the list members. Takes a list as first parameter and name or code text string as second parameter and matches the text string to list item member. You can use FINDITEM to search a list and return a matched list member, if it belongs to the list. | x: name of a list or a time period list,y: text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/finditem | ||||||||||||||||||||
36 | FIRSTNONBLANK | firstnonblank | x[FIRSTNONBLANK: y] | Shows the first non-blank text, list or date cell and uses the mapping to determine where to post the result. | x: Text, ListItem, Date, TimePeriod to search,y: ListItem, TimePeriod to use as a condition. | https://community.anaplan.com/anapedia/calculation-functions/firstnonblank | ||||||||||||||||||||
37 | FIRSTNONZERO | firstnonzero | FIRSTNONZERO(a, b) | This takes at least two numeric arguments, and returns the first that is non-zero. | a: Number,b: Number | https://community.anaplan.com/anapedia/calculation-functions/firstnonzero | ||||||||||||||||||||
38 | FV | fv | FV(r, n, [c], p, [t]) | Future value of an investment. | r: Number: Interest rate per period,n: Number: The number of periods,c: Number [opt] : Equal payments paid out each period during the course of the investment term,p: Number: Present value or the initial investment,t: Number [opt]: 0 - payments are made at the period start, 1 or non-zero - payments are made at the period end. | https://community.anaplan.com/anapedia/calculation-functions/fv | ||||||||||||||||||||
39 | HALFYEARTODATE | halfyeartodate | HALFYEARTODATE(x) | Takes a single numeric parameter and yields a cumulative sums across a half-year time range and then resets. | x: Line Item or list property containing the numeric field to summarize | https://community.anaplan.com/anapedia/calculation-functions/halfyeartodate | ||||||||||||||||||||
40 | HALFYEARVALUE | halfyearvalue | HALFYEARVALUE(x) | Returns the half-year value of the source line item, according to the time summary method set for the source. | x: Line Item or list property containing the numeric field to summarize | https://community.anaplan.com/anapedia/calculation-functions/halfyearvalue | ||||||||||||||||||||
41 | IF THEN ELSE | if then else | IF x then y else z | Conditional formula. | x: Boolean,y: Number, Boolean, Date, TimePeriod, ListItem, Text,z: Number, Boolean, Date, TimePeriod, ListItem, Text | https://community.anaplan.com/anapedia/calculation-functions/if then else | ||||||||||||||||||||
42 | IF... ISNOTBLANK | if... isnotblank | IF ISNOTBLANK(x) THEN 1 ELSE 0 | Test to see if a date, text, time period, or list formatted cell is not blank. | x: Number, Text, List, TimePeriod, or Date formatted Line Item. | https://community.anaplan.com/anapedia/calculation-functions/if... isnotblank | ||||||||||||||||||||
43 | IF… ISBLANK | if… isblank | IF ISBLANK(x) THEN 1 ELSE 0 | Tests whether a date, text, time period, or list formatted cell is blank. | x: Number, Text, List, TimePeriod, or Date formatted Line Item. | https://community.anaplan.com/anapedia/calculation-functions/if… isblank | ||||||||||||||||||||
44 | IF...AND | if...and | IF x and y then z | Tests whether 2 or more conditions are met. | x: Boolean,y: Boolean,z: Number, Text, List Item,TimePeriod, Date | https://community.anaplan.com/anapedia/calculation-functions/if...and | ||||||||||||||||||||
45 | IF...NOT | if...not | IF NOT (x) THEN 1 ELSE 0 | Tests whether condition is not true. | x: Boolean | https://community.anaplan.com/anapedia/calculation-functions/if...not | ||||||||||||||||||||
46 | IF...OR | if...or | IF x OR y THEN 1 ELSE 0 | Tests if any of 2 or more conditions is met. | x: Boolean,y: Boolean | https://community.anaplan.com/anapedia/calculation-functions/if...or | ||||||||||||||||||||
47 | INPERIOD | inperiod | INPERIOD(x) | Tests whether a date falls within the period specified on the time dimension or falls within a time period (result is Boolean formatted). | x: Date formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/inperiod | ||||||||||||||||||||
48 | IRR | irr | IRR(c, [g]) | Calculates the internal rate of return of a series of future cashflows. | c: Number Cashflow : Line Item,g: Number [opt]: Estimate of Rate: Number | https://community.anaplan.com/anapedia/calculation-functions/irr | ||||||||||||||||||||
49 | ISACTUALVERSION | isactualversion | ISACTUALVERSION() | Tests to see if the version you are on is the Actual version (result is Boolean formatted). | No Parameters | https://community.anaplan.com/anapedia/calculation-functions/isactualversion | ||||||||||||||||||||
50 | ISANCESTOR | isancestor | ISANCESTOR(a,b) | 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). | a: List formatted line items,b: List formatted line items | https://community.anaplan.com/anapedia/calculation-functions/isancestor | ||||||||||||||||||||
51 | ISBLANK | isblank | ISBLANK(x) | Tests whether an item is blank (the item must be date, text, list, or time period formatted and the result is Boolean formatted). | x : Date, Text, List, or TimePeriod formatted line item | https://community.anaplan.com/anapedia/calculation-functions/isblank | ||||||||||||||||||||
52 | ISCURRENTVERSION | iscurrentversion | ISCURRENTVERSION() | Tests to see if the version is current based on the flag that you have set in Settings > Versions | No Parameters | https://community.anaplan.com/anapedia/calculation-functions/iscurrentversion | ||||||||||||||||||||
53 | ISFIRSTOCCURRENCE | isfirstoccurrence | ISFIRSTOCCURRENCE(x,y) | Tests if a value in the source (first parameter) is the first occurrence of that value within the source (result is Boolean formatted) | x: Number, Boolean, Date, TimePeriod, ListItem, Text,y: List, Time | https://community.anaplan.com/anapedia/calculation-functions/isfirstoccurrence | ||||||||||||||||||||
54 | ISNOTBLANK | isnotblank | ISNOTBLANK(x) | Tests whether an item is not blank (the item must be date, text, list, or time period formatted and the result is Boolean formatted) | x : Date, Text, List, or TimePeriod formatted line item | https://community.anaplan.com/anapedia/calculation-functions/isnotblank | ||||||||||||||||||||
55 | ITEM | item | ITEM(x) | Returns the member of a list formatted or time period formatted line item. | x : List hierarchy or TimePeriod hierarchy that exist in the model. | https://community.anaplan.com/anapedia/calculation-functions/item | ||||||||||||||||||||
56 | LAG | lag | LAG(x, n, z,[mode]) | Take the value from n periods in the past. If this is before the start of the timescale, use z instead as the overflow value. | x: Number: Value,n: Number: Offset,z: Number : Fill value,(mode) : keyword: 'NONSTRICT', 'SEMISTRICT', and 'STRICT' | https://community.anaplan.com/anapedia/calculation-functions/lag | ||||||||||||||||||||
57 | LASTNONBLANK | lastnonblank | x[LASTNONBLANK: y] | Shows the last non-blank text, list or date cell and uses the mapping to determine where to post the result. | x: Source : Text, ListItem, Date, TimePeriod,y: Mapping : ListItem, TimePeriod | https://community.anaplan.com/anapedia/calculation-functions/lastnonblank | ||||||||||||||||||||
58 | LEAD | lead | LEAD(x, n, z,[mode]) | Take the value from n periods in the future. If this is beyond the end of the timescale, use z instead as the overflow value. | x: Number: Value,n: Number: Offset,z: Number : Fill value,(mode) : keyword: 'NONSTRICT', 'SEMISTRICT', and 'STRICT' | https://community.anaplan.com/anapedia/calculation-functions/lead | ||||||||||||||||||||
59 | LEFT | left | LEFT(x, n) | Extract substring from a string starting at the leftmost character. | x: Text: String to process,n: Number: No or characters | https://community.anaplan.com/anapedia/calculation-functions/left | ||||||||||||||||||||
60 | LEN | len | LEN(X) | Variant of LENGTH. Returns the number of characters in a text string. | x: Text formatted line item,If you use LEN(x) in the Anaplan formula bar and save it is automatically updated to LENGTH(x). | https://community.anaplan.com/anapedia/calculation-functions/len | ||||||||||||||||||||
61 | LENGTH | length | LENGTH(x) | Returns the number of characters in a text string. | x: Text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/length | ||||||||||||||||||||
62 | LN | ln | LN(x) | Returns the natural logarithm of a number, based on the constant e. | x: Number | https://community.anaplan.com/anapedia/calculation-functions/ln | ||||||||||||||||||||
63 | LOG | log | LOG(x,n) | Returns the logarithm of a number to the specified base. | x: Number: Number,n: Base: Number | https://community.anaplan.com/anapedia/calculation-functions/log | ||||||||||||||||||||
64 | LOOKUP | lookup | x[LOOKUP: y] | 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. | x: Number, Boolean, Date, TimePeriod, ListItem, Text,y: ListItem, TimePeriod | https://community.anaplan.com/anapedia/calculation-functions/lookup | ||||||||||||||||||||
65 | LOWER | lower | LOWER(x,[y]) | Converts text to lowercase. | x: Text: Text,y: Text [opt]: Locale | https://community.anaplan.com/anapedia/calculation-functions/lower | ||||||||||||||||||||
66 | MAILTO | mailto | MAILTO(u, v, w, x, y, z) | Composes the To, cc, Bcc, subject and body of an email. | u: Text: Display Text,v: Text : Email address,w: Text: Email address,x: Text: Bcc - Email address,y: Text: Subject: ,z: Text: Body text | https://community.anaplan.com/anapedia/calculation-functions/mailto | ||||||||||||||||||||
67 | MAKELINK | makelink | MAKELINK(y, z) | Composes a clickable URL. | y: Display text : Text,z: URL : Text | https://community.anaplan.com/anapedia/calculation-functions/makelink | ||||||||||||||||||||
68 | MAX | max | MAX(x,y,z) | Maximum value of selected line items. | x: Number formatted or Date formatted line items,y: Number formatted or Date formatted line items,z: Number formatted or Date formatted line items | https://community.anaplan.com/anapedia/calculation-functions/max | ||||||||||||||||||||
69 | x[MAX:y] | x[max:y] | x[MAX: y] | The maximum value for a specified member of one of the dimensions of the target. The source will have a list formatted item for this dimension. | x: Number,y: Listitem, TimePeriod | https://community.anaplan.com/anapedia/calculation-functions/x[max:y] | ||||||||||||||||||||
70 | MID | mid | MID(x, y, n) | Extract a substring from a string starting at any character. | x: Text: String to process,y: Number: Start Position,n: Number: Number of characters to extract | https://community.anaplan.com/anapedia/calculation-functions/mid | ||||||||||||||||||||
71 | MIN | min | MIN(x,y,z) | Minimum of selected line items. | x: Number formatted or Date formatted line items,y: Number formatted or Date formatted line items,z: Number formatted or Date formatted line items | https://community.anaplan.com/anapedia/calculation-functions/min | ||||||||||||||||||||
72 | x[MIN:y] | x[min:y] | x[MIN:y] | The minimum value for a specified member of one of the dimensions of the target. The source will have a list formatted item for this dimension. | x: Number or date formatted source line item,y: Source line item which is list formatted for a dimension that applies to the result/target. | https://community.anaplan.com/anapedia/calculation-functions/x[min:y] | ||||||||||||||||||||
73 | MOD | mod | MOD(x,n) | Modulus: remainder after dividing a dividend by a divisor. | x: Number : Dividend,n: Number : Divisor | https://community.anaplan.com/anapedia/calculation-functions/mod | ||||||||||||||||||||
74 | MONTH | month | MONTH(x) | Converts a date or a time period to a calendar month as number. | x: Date formatted or TimePeriod formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/month | ||||||||||||||||||||
75 | MONTHTODATE | monthtodate | MONTHTODATE(x) | Takes a single numeric parameter and yields a cumulative sums across a month time range and then resets. | x: Numeric line item or a Numeric value which is a function result. | https://community.anaplan.com/anapedia/calculation-functions/monthtodate | ||||||||||||||||||||
76 | MONTHVALUE | monthvalue | MONTHVALUE(x) | Returns the month value of the source line item, according to the time summary method set for the source. | x : Source line item or property | https://community.anaplan.com/anapedia/calculation-functions/monthvalue | ||||||||||||||||||||
77 | MROUND | mround | MROUND(n, m, r) | Round to the nearest desired multiple. | n: Number : Number,m: Multiple : Number,r: Rounding Rule : 'DOWN', 'UP', 'NEAREST', 'TOWARDSZERO', 'AWAYFROMZERO' | https://community.anaplan.com/anapedia/calculation-functions/mround | ||||||||||||||||||||
78 | MOVINGSUM | movingsum | MOVINGSUM(n, f, t, a) | Calculates moving values, such as a moving sum or moving average. | n: Item : Number, Boolean, Date, TimePeriod, ListItem, Text - The line item that varies over time,f : From: Number - the time range for the MOVINGSUM calculation,t : To: Number - the time range for the MOVINGSUM calculation,a: Aggregate : SUM, AVERAGE, MIN, MAX, ANY, ALL, FIRSTNONBLANK, LASTNONBLANK, TEXTLIST | https://community.anaplan.com/anapedia/calculation-functions/movingsum | ||||||||||||||||||||
79 | NAME | name | NAME(x) | Converts a list item or time period to text. | x: List formatted or TimePeriod formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/name | ||||||||||||||||||||
80 | NEXT | next | NEXT(x) | Returns a value from the next period. | x: Number, Boolean, Date, TimePeriod, List, or Text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/next | ||||||||||||||||||||
81 | NEXTVERSION | nextversion | NEXTVERSION(x) | Returns a value from the next version. | x: Number, Boolean, Date, TimePeriod, List, or Text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/nextversion | ||||||||||||||||||||
82 | NOT | not | NOT(x) | Tests to see if a condition is not met (result is Boolean formatted). | x: Number, Boolean, Date, TimePeriod, List, or Text formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/not | ||||||||||||||||||||
83 | NPER | nper | NPER(r, [c], p, [f], [t]) | The length in periods of the investment term. | r: Number: Interest rate per period,c: Number[opt] : Equal payments paid out each period during the course of the investment term,p: Number: Present value or the initial investment,f: Number[opt] : Future residual value at the end of the term,t: Number[opt] : 0 - payments made at period start, 1 or non-zero -payments made at period end. | https://community.anaplan.com/anapedia/calculation-functions/nper | ||||||||||||||||||||
84 | NPV | npv | NPV(d, c) | Calculates the net present value of a series of cashflows using a constant interest rate. | d: Number: Discount Rate,c: Number: Cashflow | https://community.anaplan.com/anapedia/calculation-functions/npv | ||||||||||||||||||||
85 | OFFSET | offset | OFFSET(x,n,z) | Returns a value from a specified number of periods in advance. | x: Number, Boolean, Date, TimePeriod, ListItem, Text: Source,z: Number, Boolean, Date, TimePeriod, ListItem, Text: Periods,n: Number: Fill | https://community.anaplan.com/anapedia/calculation-functions/offset | ||||||||||||||||||||
86 | OR | or | 1) x OR y 2) OR(x,y,z) | Tests to see if any of two or more conditions is met. | 1) x, y: Boolean,2) x, y, z: Boolean | https://community.anaplan.com/anapedia/calculation-functions/or | ||||||||||||||||||||
87 | PARENT | parent | PARENT(x) | 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. | x: List formatted or TimePeriod formatted line item. | https://community.anaplan.com/anapedia/calculation-functions/parent | ||||||||||||||||||||
88 | PERIOD | period | PERIOD(x) | Take a date as parameter and yields a time period as result. | x: Date | https://community.anaplan.com/anapedia/calculation-functions/period | ||||||||||||||||||||
89 | POST | post | POST(x, n) | Post a value to a specified number of periods in the future. | x: line item formatted to number : value to be returned,n: offset number (negative value retrieves POST from the future, postive value retrieves POST from past) | https://community.anaplan.com/anapedia/calculation-functions/post | ||||||||||||||||||||
90 | POWER | power | POWER(x,n) | Raise a value to a power. | x: Number: Base number,n: Number: Exponent | https://community.anaplan.com/anapedia/calculation-functions/power | ||||||||||||||||||||
91 | PMT | pmt | PMT(r, n, p, [f], [t]) | Calculates the payments for a loan or annuity with constant payments and a constant interest rate. | r: Number: The interest rate per period,n: Number: The number of periods,p: Number: The present value or the initial investment,f: Number[opt] : The future or residual value,t: Number[opt] : When payments are made. 0 (or omitted) - payments are made at the period end, 1 - payments are made at period start. | https://community.anaplan.com/anapedia/calculation-functions/pmt | ||||||||||||||||||||
92 | PREVIOUS | previous | PREVIOUS(x) | Takes a value from the previous period. | x: Number, Boolean, Date, TimePeriod, ListItem, Text | https://community.anaplan.com/anapedia/calculation-functions/previous | ||||||||||||||||||||
93 | PREVIOUSVERSION | previousversion | PREVIOUSVERSION(x) | Takes a value from the previous version. | x: Number, Boolean, Date, TimePeriod, ListItem, Text | https://community.anaplan.com/anapedia/calculation-functions/previousversion | ||||||||||||||||||||
94 | PROFILE | profile | PROFILE(x, y) | Allocates a value over the next few periods based on a table containing % current period, % next period, % pd+2 etc. | x: Number,y: Profile % Allocations | https://community.anaplan.com/anapedia/calculation-functions/profile | ||||||||||||||||||||
95 | PV | pv | PV(r, n, [c], [f], [t]) | Calculates the present value of future cashflows. | r: Number: The interest rate per period,n: Number: The number of periods,c: Number: The equal payments paid out each period during the course of the investment term,f: Number[opt]: The future or residual value,t: Number[opt]: When payments are made. 0 (or omitted) - payments are made at the period end, 1 - payments are made at period start. | https://community.anaplan.com/anapedia/calculation-functions/pv | ||||||||||||||||||||
96 | QUARTERTODATE | quartertodate | QUARTERTODATE(x) | Takes a single numeric parameter and yields a cumulative sums across a quarter time range and then resets. | x: Numeric line item or a Numeric value which is a function result. | https://community.anaplan.com/anapedia/calculation-functions/quartertodate | ||||||||||||||||||||
97 | QUARTERVALUE | quartervalue | QUARTERVALUE(x) | Returns the quarter value of the source line item, according to the time summary method set for the source. | x: Source line item or property. | https://community.anaplan.com/anapedia/calculation-functions/quartervalue | ||||||||||||||||||||
98 | RANK | rank | RANK(v,[w],[x],[y],[z]) | Orders a set of values and assigns rankings from 1 to a specified ending rank. | v: Number: Source values to rank,w: Keyword [opt] ::Direction: 'DESCENDING', 'ASCENDING',x: Keyword [opt] : Ties 'MINIMUM', 'MAXIMUM', 'AVERAGE', 'SEQUENTIAL',y: Boolean [opt]: Include the value in the ranking,z: Number, List, Date, Boolean, Text, or TimePeriod formatted [opt]: Grouping. | https://community.anaplan.com/anapedia/calculation-functions/rank | ||||||||||||||||||||
99 | RANKCUMULATE | rankcumulate | RANKCUMULATE(v,w,[x],[y],[z]) | Allows you to cumulate line item values based on ranking criteria, which might contain groupings. Can be used against lists but not time. | v: Numeric line item, property, or expression: The source values to be cumulated,w: Line Item: numeric, date, or time line item, property, or expression: The value by which results are ranked,x: Keyword [opt]: Whether the results will be displayed in ascending or descending order [opt],y: Boolean [opt]:Whether the corresponding ranking value, and therefore cumulation value, is included,z: Number, Text, Date, List, Boolean, or TimePeriod formatted line item, property, or expression [opt]:Determines the partitioning of the rankings [opt]. | https://community.anaplan.com/anapedia/calculation-functions/rankcumulate | ||||||||||||||||||||
100 | RATE | rate | RATE(n, [c], p, [f], [t], [e]) | Calculates a per period interest rate. | n: Number: Number of periods,c: Number [opt]: Equal payments paid out each period during the course of the investment term,p: Number: Present value or the initial investment,f: Number [opt]: Future residual value at the end of the term,t: Number [opt]: 0 or omitted - payments made at period start : 1 or non-zero - payments made at period end,e: Number [opt]: Estimate of what the rate will be. | https://community.anaplan.com/anapedia/calculation-functions/rate |