# Numeric Equation Functions Updated by Danielle Kellogg

This information is referenced in the Equations article.

The functions listed on this page are only available for Equation Fields. If you're looking for the functions available for Text Formula fields, click here.
The equation type must be set to "numeric" to use these functions.

Many regular math functions (such as "ceil" or "max") can be used in Knack numeric equations. Others, like "getDateDayOfMonth" provide numeric values for a date.

 Name Description Example with Result cbrt Calculate the cube root of a number cbrt(27)=3 ceil Round a value up to the nearest integer ceil(4.2) = 5 cos Calculate the cosine of a number cos(2) = -0.4161468365471424 factorial Compute the factorial of a number factorial(5) = 120 gcd Calculate the greatest common denominator of a comma-separated list of numbers gcd(5, 25) = 5 log Calculate the logarithm of a number. First number is value for which to calculate, second is the base log(10,4) = 1.6609640474436813 log10 Calculate a base 10 logarithm. Same as log(x, 10) log10(4) = 0.6020599913279623 max Get the maximum of a comma-separated list of values max(1,6,9) = 9 mean Compute the mean of a list of values mean(1,6,8) = 5 median Compute the median of a list of values median(8,9,1) = 8 min Get the minimum of a list of values min(43,100,3) = 3 pow Calculate the base to the exponent power pow(7,2) = 49 random Get a random number between two values random(1,42) = 36.238172 randomInt Get a random integer between two values randomInt(1,42) = 36 sign Calculate the sign of a number: -1 if number is less than 0, 1 if number is greater than 0, 0 if number is 0 sign(2) = 1 sin Calculate the sine of a number sin(15) = 0.6502878401571168 std Compute the standard deviation of a list of values std(1,5,42,78) = 36.07861785970558 sqrt Calculate the square root of a number sqrt(81) = 9 sum Compute the sum of a list of values sum(1,42,56) = 99 tan Calculate the tangent of a number tan(16) = 0.3006322420239034 var Compute the variance of a list of values var(1,42,34,67) = 742 netWorkDays Get the number of working/business days between two dates. netWorkDays(06/18/2018,06/27/2018) = 7

The following examples use April 15, 2017 as the date.

 getDateDayOfWeek Get the numeric day of the week from a Date (Sunday = 1) getDateDayOfWeek({Date}) = 7 getDateDayOfMonth Get the numeric day of the month from a Date getDateDayOfMonth({Date}) = 15 getDateWeek Get the numeric week of the year from a Date getDateWeek({Date}) = 15 getDateMonth Get the numeric month from a Date getDateMonth({Date}) = 4 getDateQuarter Get the numeric quarter from a Date getDateQuarter({Date}) = 2 getDateYear Get the numeric year from a Date getDateYear({Date}) = 2017

### How did we do?

#### Field Types 