Numeric Equation Functions

This article will provide example numeric equation field functions to use and their descriptions.

Note: The functions listed on this page are only available for equation fields. If you're looking for the functions available for text formula fields, see our article here.

 

Many regular math functions (such as "ceil" or "max") can be used in Knack numeric equations. Others, such as 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

 floor

 Round a value down to the nearest           integer 

  floor(2.8) = 2

gcd

Calculate the greatest common denominator of a comma-separated list of numbers

gcd(5, 25) = 5

log

Calculate the logarithm of a number. The first number is the value for which to calculate, the 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 the number is less than 0, 1 if the number is greater than 0, 0 if the 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