Function formulas available on the studio – Ermeo Academy

Why the functions are useful ?

The functions in the studio will allow you to perform calculations quickly, directly within your Ermeo application.

What is the list of usable functions ?

Function	Description	Specificity	Widget type
abs(x)	Calculates the absolute value of the number x passed as an argument		Number
cube(x)	Calculates the cubed multiplication of the number x passed as an argument		Number
gcd(x,y)	gcd(x,y): Calculates the greatest common divisor between the numbers x and y passed as arguments		Number
mod(x,y)	mod(x,y): Calculates the remainder of the modulo division of the numbers x divided by y		Number
pow(x,y)	pow(x,y): Calculates the power of the number x by y (x^y)		Number
sign(x)	sign(x): Returns -1 if the number x passed as argument is negative, or 1 if the number x passed as argument is positive (or zero)		Number
square(x)	square(x): Returns the result of multiplying the value x passed as an argument by itself (x*x)		Number
round(x)	Calculates the rounded value of the number x passed as an argument. The returned value is the nearest whole number (rounded down or up). It is not possible to choose between rounding up or rounding down.	Specific with decimal	Number
compare(x,y)	Returns 1 if the number x passed as argument is greater than the number y passed as argument. Returns -1 if y is greater than x. Returns 0 if x is equal to y.		Number
equal(x,y)	Returns 1 if the numbers x and y passed as arguments are equal. Returns 0 if x and y are different.		Number
unequal(x,y)	Returns 1 if the numbers x and y passed as arguments are different. Returns 0 if x and y are equal.		Number
larger(x,y)	Returns 0 if the number y passed as argument is greater than or equal to the number x passed as argument. Returns -1 if y is less than x.		Number
smaller(x,y)	Returns 1 if x is less than or equal to y. Returns 0 if x is greater than y		Number
max(a,b,c)	Returns the largest value among the values a,b and c		Number
min(a,b,c)	Returns the smallest value among the values a,b and c		Number
mean(a,b,c)	Returns the average of the values a,b and c passed as an argument.		Number
variance(a,b,c)	Returns the variance of the values a,b and c passed as an argument		Number
hasNumericValue(x)	Returns 1 if the x value passed as argument is a number.		Number
isInteger(x)	Returns 1 if the value x passed as an argument is an integer		Number
isNegative(x)	Returns 1 if the value x passed as argument is a negative number. Returns 0 if the number is strictly greater than 0		Number
isPositive(x)	Returns 1 if the value x passed as argument is a positive number. Returns 0 if the number is strictly less than 0.		Number
isZero(x)	Returns 1 if the value x passed as argument is equal to 0. Returns 1 if the number is different from 0		Number
Count	https://support.ermeo.com/hc/en-us/articles/4407710265490-Identify-the-number-of-iterations		Number
Random	https://support.ermeo.com/hc/en-us/articles/360011823919-Creating-a-formula-in-Number-widget-		Number
Iteration	##name_of_the_task[1]## : corresponds to the iteration number of the repeatable section or the creation widget. Example: It is useful to obtain the value of a specific iteration. It helps to calculate all the widgets "number" of a repeatable section through the calculation of the iterations.		Number, text ...
##report_id##	Having a unique report alphanumeric number creates the uniqueness of a report.	It can only be used in the custom templates and not the design studio	Custom template

To use these functions, you must place the name of the function within the calc formula.

Practical example: We are going to use the mean function to calculate the average of two numbers.

1. Drag and drop two Number tiles into your form. Name them "Number 1" and Number 2".

2. Drag and drop a third Number brick. Name it "Average Result".

3. Write the following formula in the formula field: calc(mean(Number1,Number2))

4. Launch the form in preview to observe the average of the numbers.

Why the functions are useful ?

What is the list of usable functions ?

Related articles