Math Expression in Appsheet feature in Appy Pie.

Math Expression in Appsheet feature in Appy Pie.

Math Operators

MAX

The greatest value/item in the list is returned by MAX function.

Syntax

MAX(list-to-choose-max-value-from)

Example
 
MAX(LIST(22,50,45)) : 45
 
MAX(Order[Price]): This represents the greatest value in the Price column of the Order table.
 
MAX([Quantity]): This represents the greatest value of all items in the Quantity column value, where Quantity is of type List.
 
Arguments

The list must be numeric. There can be two cases:

  • A constructed list (e.g., with LIST())

  • A column list (e.g., Order[Price])


 Return Value

The greatest value in the list.

Learn more about MAX


MIN

The least value/item in the list is returned by MIN function.

Syntax

MIN(list-to-choose-min-value-from)

Example

MIN(LIST(1,7,66)) : 1
MIN(Order[Price]) : This represents the least value in the Price column of the Order table.
MIN([Quantity]) : This represents the least of all items in the Quantity column value, where Quantity is of type List.

Arguments
 The list must be numeric. There can be two cases:

  • A constructed list (e.g., with LIST())

  • A column list (e.g., Order[Price])


 Return Value

The least value in the list.

Learn more about MIN


AVERAGE

The arithmetic average of list items is returned by the AVERAGE function.

Syntax

AVERAGE(LIST())

Example

AVERAGE(LIST(78,4,86)) : 56

AVERAGE(Order[Price]) : This represents the arithmetic average of all values in the Price column of the Order table. 

AVERAGE([Quantity]) : This represents the arithmetic average of all items in the Quantity column value, where Quantity is of type List for some numeric type.

AVERAGE(LIST(1, 7, 4)) : 4

AVERAGE(LIST(0) - LIST(0)) (a valid constructed list with a type but no items): 0.00

Arguments

The list must be numeric of any type.
 
Return Value

Decimal: The computed average of the values of list.

Learn more about AVERAGE


COUNT

The total number of items in the list is returned by the COUNT function.

Syntax
 
COUNT(list-to-count)
 
Example
 

COUNT(LIST(45,54,71,5,6)) : 5
 
COUNT(Order[Color]) : This represents the total number of (possibly duplicate) values in the Color column of the Order table.
 
COUNT([Quantity]) : This represents the count of the items in the Quantity column value, where Quantity is of type List.
 
COUNT(LIST("Red", "Yellow", "Blue")) : 3
 
COUNT(LIST()) : 0

Arguments

The list must be numeric of any type.

Return Value

Number: The count of items in the list.
 
Learn more about COUNT


ROUND

The ROUND function returns the closest value to ‘x’ where x can be any number.

Syntax

ROUND(number-to-round)

Example

Round(4.4) : 4

Round(4) : 4

Round(-4.4) : -4
 
Round(4.8) : 5

Arguments

x (any numeric type).

Return Value

Number: The number nearest x.

Learn more about ROUND


SQRT

The square root of the number is returned by SQRT function.
 
Syntax

SQRT(numeric-value)
 
Example
 
SQRT(4) : 2
 
SQRT(2) : 1.414
 
SQRT(3) : 1.73
 
SQRT(2) : 1.41
 
SQRT(1) : 1.00
 
SQRT(0) : 0.00
 
SQRT(-1) (or any negative number): NaN ("not a number")
 
Arguments

Integer x (any type).
 
Return Value

Decimal: The square root of x, where x is an integer.

Learn more about SQRT


Distance

DISTANCE returns the approximate distance in kilometers between two locations expressed as LatLong values. DISTANCE() does not work with Address values.

Syntax

DISTANCE(location_1, location_2))

Example    

DISTANCE('28.5407217,77.3964503','28.5407217,77.3964503')  


POWER

The arithmetic exponentiation of the base number is returned by the POWER function.
 
Syntax
 
POWER(base, exponent)
 
Example

POWER(10,2) : 100
 
POWER(-2.23, 3) : -11.09
 
POWER(-2.23, 2) : 4.97
 
POWER(-2.23, 1) : -2.23
 
POWER(-2.23, 0) : 1.00
 
POWER(-2.23, -1) : -0.45
 
POWER(-2.23, -2) : 0.20
 
POWER(-2.23, -3) : -0.09
 
Arguments

Integers x and y (of any type).

Return Value

Decimal: x raised to the power of y, where x and y both are integers.

Learn more about POWER


ABS

The arithmetic absolute value of the number is returned by the ABS function.

Syntax

ABS(numeric-value)

Example

ABS(-77) returns Number: 77

ABS(0) returns Number: 0

ABS(1) returns Number: 1
 
ABS(-1) returns Number: 1
 
ABS(0.0) returns Decimal: 0
 
ABS(4.16) returns Decimal: 3.14
 
ABS(-4.16) returns Decimal: 3.14

Arguments

Integer x (any type)
 
Return Value

The absolute value of x, where x is an integer.

Learn more about ABS


FLOOR

The nearest integer value less than or equal to x (where x is an integer) is returned by the FLOOR function.

Syntax

FLOOR(number-to-round-down)
 
Example

FLOOR(10.69) : 10
 
FLOOR(3.14) : 3
 
FLOOR(-3.14) : -4
 
FLOOR(5) : 5
 
Arguments

Integer x (any type)

Return Value

Number: The nearest integer less than or equal to x, where x is an integer.

Learn more about FLOOR


CEILING

The CEILING function rounds a number up to the nearest integer multiple of specified significance.

Syntax

CEILING(number-to-round-up)
 
Example
 
CEILING(10.98) : 10
 
CEILING(3.14) : 4
 
CEILING(-3.14) : -3
 
CEILING(5) : 5
 
Arguments
 
Integer x (any type)
 
Return Value
 
Number: The nearest integer greater than or equal to x, where x is an integer.
 
Learn more about CEILING


Number

Number always returns the number value.

Syntax

NUMBER(value-to-convert-to-number)    

Example

NUMBER(10) : 10


DECIMAL

The DECIMAL function returns the exact value.

Syntax

DECIMAL(value-to-convert-to-decimal)

Example

DECIMAL(8.4) : 8.4

DECIMAL(8.0) : 8.0


STDEVP

The arithmetic standard deviation of list items is returned by the STDEVP function.

Syntax

STDEVP(list)

STDEVP(LIST([COLUMN_0],...[COLUMN_N]))

Example

STDEVP(LIST(1, 2, 3)) : 0.84
 
STDEVP(Order[Price]) : This represents the standard deviation of values in the Price column of the Order table.
 
STDEVP([Quantity]) : This represents the standard deviation for the items in the Quantity column value, where Quantity is of type List.
 
STDEVP(LIST(1, 2, 3)) : 0.82

Arguments

The list must be numeric. There can be two cases:

  • A constructed list (e.g., with LIST())

  • A column list (e.g., Order[Price])


 Return Value

Decimal: The computed standard deviation of the values in list.

Learn more about STDEVP


SUM

The arithmetic sum of list items is returned by the SUM function.

Syntax

SUM(list)

SUM(LIST([COLUMN_0],...[COLUMN_N]))

Example

SUM(LIST(2,10)) : 12

SUM(Classes[Seat Count]) : This represents the sum of all values in the Seat Count column of the Classes table.
 
SUM([Quantity]) : This represents the sum of the items in the Quantity column value, where Quantity is of type List.
 
SUM(LIST(1, 2, 4)) : 7

Arguments

The list must be numeric. There can be two cases:

  • A constructed list (e.g., with LIST())

  • A column list (e.g., Order[Price])


 Return Value

The computed sum of the values in some-list.




 

Share this :

Was this article helpful?

Reviews on this page are powered by Trustpilot where Appy Pie is rated 4.9 with 2118+ Excellent reviews.You can post a review for Appy Pie on Trustpilot by clicking on Write a review.