The following is a list of all available functions that can be used in the User Defined Fields of WTP grids.
@PI()
The value of pi.
@RAND()
A uniform random number on the interval (0,1).
@GRAND()
A 12th-degree binomial approximation to a Gaussian random number with zero mean and unit variance.
@ABS(X)
The absolute value of X.
@CEIL(X)
The smallest integer greater than or equal to X.
@EXP(X)
e raised to the X power.
@FACT(N)
The value of N.
@FLOOR(X)
The largest integer less than or equal to X.
@FRAC(X)
The fractional portion of X.
@INT(X)
The integer portion of X.
@ROUND(X, n)
X rounded to n number of decimal places (0 to 15).
@SQRT(X)
The positive square root of X.
@MOD(X, Y)
The remainder of X/Y.
@MODULUS(X, Y)
The modulus of X/Y.
---------------------------------------------------------------------------------
@LNGAMMA(X)
The log base e of the gamma function evaluated at X.
@LOG(X)
The log base 10 of X.
@LOG10(X)
The log base 10 of X.
@LOG2(X)
The log base 2 of X.
@LN(X)
The natural log (base e) of X.
---------------------------------------------------------------------------------
@AVG(...)
The average (arithmetic mean) of its arguments.
@MAX(...)
The maximum of its arguments.
@MEDIAN(...)
The median (middle value) of the range R1.
@MIN(...)
The minimum of its arguments.
@MODE(...)
The mode or most frequently occurring value.
@MSQ(...)
The mean of the squares of its arguments.
@PRODUCT(X, ...)
The product of all the numeric values in the argument list.
@SUM(...)
The sum of its arguments.
---------------------------------------------------------------------------------
@GMEAN(...)
The geometric mean of its arguments.
@HMEAN(...)
The harmonic mean of its arguments.
@RMS(...)
The root of the mean of squares of its arguments.
@SSQ(...)
The sum of squares of its arguments.
@SSE(...)
The sum squared error of its arguments. It is equivalent to @VAR(...) @COUNT(...).
@STD(...)
The population standard deviation (N weighting) of its arguments.
@STDS(...)
The sample standard deviation (N-1 weighting) of its arguments.
@VECLEN(...)
The square root of the sum of squares of its arguments.
@VAR(...)
The sample variance (N weighting) of its arguments.
@VARS(...)
The sample variance (N-1 weighting) of its arguments.
@VSUM(...)
The visual sum of its arguments, using precision and rounding of formatted cell values.
---------------------------------------------------------------------------------
@F(M, N, F)
The integral of Snedecor's F-distribution with M and N degrees of freedom from minus infinity to F.
@ERF(L[, U])
Error function integrated between 0 and L; if U specified, between L and U.
@ERFC(L)
Complementary error function integrated between L and infinity.
@GAMMA(X)
The value of the gamma function evaluated at X.
@SIGMOID(X)
The value of the sigmoid function.
@T(N, T)
The integral of Student's T-distribution with N degrees of freedom from minus infinity to T.
@POLY(X, ...)
The value of an Nth-degree polynomial in X.
---------------------------------------------------------------------------------
@ACOS(X)
The arc cosine of X.
@ASIN(X)
The arc sine of X.
@ATAN(X)
The 2-quadrant arc tangent of X.
@ATAN2(X, Y)
The 4-quadrant arc tangent of Y/X.
@COS(X)
The cosine of X.
@COSH(X)
The hyperbolic cosine of X.
@DEGREES(X)
Converts the angle expressed in radians to degrees ( ).
@RADIANS(X)
Converts the angle expressed in degrees to radians ( ).
@SIN(X)
The sine of X.
@SINH(X)
The hyperbolic sine of X.
@TAN(X)
The tangent of X.
@TANH(X)
The hyperbolic tangent of X.
Note: Arguments for string functions are placed between quotation marks.
---------------------------------------------------------------------------------
@CHAR(N)
The character represented by the code N (ASCII): RETURN TYPE - STRING
@CODE(S)
The ASCII code for the first character in string S: RETURN TYPE - NUMERIC
@HEXTONUM(S)
The numeric value for the hexadecimal interpretation of S.
@NUMTOHEX(X)
The hexadecimal representation of the integer portion of X.
@VALUE(S)
The numeric value represented by the string S; otherwise 0 if S does not represent a number.
@STRING(X, N)
The string representing the numeric value of X, to N decimal places.
---------------------------------------------------------------------------------
@LOWER(S)
S converted to lower case.
@UPPER(S)
The string S converted to upper case.
@TRIM(S)
The string formed by removing spaces from the string S.
@PROPER(S)
The string S with the first letter of each word capitalized.
@CLEAN(S)
The string formed by removing all non-printing characters from the string S.
---------------------------------------------------------------------------------
@LENGTH(S)
The number of characters in S.
@STRLEN(...)
The total length of all strings in its arguments.
@STRCAT(...)
The concatenation of all its arguments.
@LEFT(S, N)
The string composed of the left-most N characters of S.
@MID(S, N1, N2)
The string of length N2 that starts at position N1 in S.
@RIGHT(S, N)
The string composed of the right-most N characters of S.
@REPEAT(S, N)
The string S repeated N times.
@REPLACE(S1, N1, N2, S2)
The string formed by replacing the N2 characters starting at position N1 in S1 with string S2.
---------------------------------------------------------------------------------
@EXACT(S1, S2)
Returns true (1) if string S1 exactly matches string S2, otherwise returns 0.
@FIND(S1, S2, N)
The index of the first occurrence of S1 in S2.
@REGEX(S1, S2)
Returns true (1) if string S1 exactly matches string S2; otherwise returns false (0). Allows "wildcard"' comparisons by interpreting S1 as a regular expression.
@FALSE()
The logical value 0.
@TRUE()
The logical value 1.
@ISNUMBER(X)
1 if X is a numeric value; otherwise 0.
@ISSTRING(X)
1 if X is a string value; otherwise 0.
---------------------------------------------------------------------------------
@AND(...)
0 if any arguments are 0; 1 if all arguments are 1; otherwise -1.
@NAND(...)
0 if all arguments are 1; 1 if any arguments are 0; otherwise -1.
@NOR(...)
0 if any arguments are 1; 1 if all arguments are 0; otherwise -1.
@NOT(X)
0 if X=1; 1 if X=0; otherwise -1.
@OR(...)
0 if all arguments are 0; 1 if any arguments are 1; otherwise -1.
@XOR(...)
-1 if any of the arguments are not 0 or 1; otherwise 0 if the total number of arguments with the value 1 is even; 1 if the total number of arguments with the value 1 is odd.
@IF(X, T, F)
The value of T if X evaluates to 1, or F if X evaluates to 0. (equivalent with ternary).
---------------------------------------------------------------------------------
@NOW()
The date/time value of the current system date and time.
@TODAY()
The date value of the current system date.
---------------------------------------------------------------------------------
@DATE(Y, M, D)
The date value for year Y, month M, and day D.
@DATEVALUE(S)
The corresponding date value for a given string S.
@TIME(H, M, S)
The time value for hour H, minute M, and second S.
@TIMEVALUE(S)
The corresponding time value for a given string value S.
---------------------------------------------------------------------------------
@YEAR(DT)
The year value of date/time value DT.
@MONTH(DT)
The number of the month in date/time value DT.
@DAY(DT)
The day number in the date/time value DT.
@HOUR(DT)
The hour value (0-23) of date/time value DT.
@MINUTE(DT)
The minute value (0-59) of date/time value DT.
@SECOND(DT)
The seconds value (0-59) of the date/time value DT.
@WEEKDAY(D)
The integer representing the day of the week on which the day D falls. 1 is Sunday, 7 is Saturday.
---------------------------------------------------------------------------------
@DAYS360(S, E)
The number of days between two dates, based on a 30/360 day count system.
@EDATE(S, M)
The date/time value representing number of months (M) before or after start date (S).
@EOMONTH(S, M)
The date/time value representing the last day of the month M months after S, if M is positive, or M months before if M is negative.
@NETWORKDAYS(S, E[, H])
The number of whole working days, starting at S and going to E, excluding weekends and holidays.
@WORKDAY(S, D[, H])
The day that is D working days after S, if D is positive, or before S, if D is negative, excluding weekends and all holidays specified as dates in range H.
@YEARFRAC(S, E)
The portion of the year represented by the number of days between start date (S) and end date (E).
© 2015 Wolverine Execution Services, LLC