Below is a list of functions available to use withing an Expression :

## Arithmetic

Those are simple mathematical functions used to make calculations.

### Add +

(Number1 + Number2)

Sum of Number1 and Number2

### Substract -

(Number1 - Number2)

Substract Number1 and Number2

### Multiply *

(Number1 * Number2)

Multiply Number1 and Number2

### Divide /

(Number1 / Number2)

Divide Number1 by Number2

### Modulo %

(Number1 % Number2)

Modulo of Number1 and Number2

### Absolute value Abs

Abs(Number1)

Absolute value of Number1

### Square Root Square Root

Square Root(Number1)

Square Root of Number1

### Exponential Exp

Exp(Number1)

Exponential of Number1

### Logarithm Log

Log(Number1)

Natural logarithm of Number1

### Power Power

(Number1 Power Number2)

Number1 raised to power Number2

### Rounding Round

(Number1 Round Decimals)

Number1 rounded to the nearest Decimals

### Sign Sign

Sign(Number1)

Number indicating the sign of Number1 :

• -1 if Number1 &lt; 0
• 0 if Number1 = 0
• +1 if Number1 &gt; 0

## Boolean

Those functions are boolean operators used in logical expressions (with the If function for example).

### Conjunction And

(Expression1 And Expression2)

Logical conjunction of boolean Expression1 and Expression2

### Disjunction Or

(Expression1 Or Expression2)

Logical disjunction of boolean Expression1 or Expression2

### Negation Not

Not(Expression1)

Logical negation of boolean Expression1

## Aggregation

These Aggregation functions play a special role in Expressions, please see chapters Aggregated Expressions and Expressions Troubleshooting
In particular, they apply differently on each Widget’s result set differently, depending on the grouping configured in the Widget.

### Average Avg

Avg(Field1)

Average of all values in Field1

### Count Count

Count(Field1)

Count all non- NULL values in Field1

### Distinct Count Distinct Count

Distinct Count(Field1)

Count all distinct and non- NULL values in Field1

### Maximum Max

Max(Field1)

Maximum of all values in Field1

### Minimum Min

Min(Field1)

Minimum of all values in Field1

### Summation Sum

Sum(Field1)

Sum total of all values in Field1

### Standard Deviation STDev

STDev(Field1)

Statistical standard deviation of all values in Field1

### Standard Deviation for population STDevP

STDevP(Field1)

Statistical standard deviation for the population of all values in Field1

### Variance Var

Var(Field1)

Statistical variance of all values in Field1

### Variance for population VarP

VarP(Field1)

Statistical variance for the population of all values in Field1

## Geometry

Those are simple mathematical functions used to make calculations.

### π Pi

Pi

Mathematical constant Pi

Sin(Number1)

Sine of Number1

### Cosine Cos

Cos(Number1)

Cosine of Number1

### Tangent Tan

Tan(Number1)

Tangent of Number1

### Arc Cosine ACos

ACos(Number1)

Inverse of Cosine of Number1

### Arc Sine Asin

Asin(Number1)

Inverse of Sine of Number1

### Arc Tangent ATan

ATan(Number1)

Inverse of Tangent of Number1

### Degrees Degrees

Degrees(Number1)

Convert Number1 radians to degrees

### Radians Radians

Radians(Number1)

Convert Number1 degrees to radians

## String

Those are functions used to manipulate strings and characters.

### Character Char

Char(Number1)

Convert the Number1 integer ASCII code to a character value

### Concatenate Concat

(String1 Concat String2)

Concatenate String1 and String2 to form a single string

### Contains Contains

(String1 Contains String2)

Search String1 for any occurrence of String2 and return :

• true or 1 if String1 contains occurrences of String2
• false or 0 otherwise

### Starts with Starts with

(String1 Starts with String2)

Check if String1 starts with String2 and return :

• true or 1 if String1 starts with String2
• false or 0 otherwise

### Ends with Ends with

(String1 Ends with String2)

Check if String1 ends with String2 and return :

• true or 1 if String1 ends with String2
• false or 0 otherwise

### Left Left

(String1 Left Number1)

Return the Number1 left-most characters of String1

### Right Right

(String1 Right Number1)

Return the Number1 right-most characters of String1

### Length Length

Length (String1)

Return the number of characters for String1

### Lower Lower

Lower (String1)

Return String1 as lower-case

### Upper Upper

Upper (String1)

Return String1 as lower-case

### RTrim RTrim

RTrim (String1)

removes right trailing spaces from String1

### LTrim LTrim

LTrim (String1)

removes left trailing spaces from String1

### Substring Substring

Substring (String1 , Number1 , Number2)

Return part of String1 starting from Number1 with Number2 number of character

## Date

### Now Now

Now

Return current date and time

### Today Today

Today

Return current date

### Hour Hour

Hour (Date1)

Returns the Hour of the time (from 0 to 23) from Date1.

### Minute Minute

Minute (Date1)

Returns the minute of the time (from 0 to 59) from Date1.

### Second Second

Second (Date1)

Returns the second of the time (from 0 to 59) from Date1.

### Month Month

Month (Date1)

Returns the month of the year (from 1 to 12) from Date1.

### Month Year MonthYear

Month Year (Date1)

Returns the month and the year of the date from Date1.

### Year Year

Year (Date1)

Returns the year of the date from Date1.

### Week Week

Week (Date1)

Return the week number (from 1 to 52) from Date1.

### Quarter Quarter

Quarter (Date1)

Return the Quarter of the year (from 1 to 4) from Date1.

### Quarter Year QuarterYear

Quarter Year (Date1)

Return Year and quarter of the date from Date1.

### Day of week Dayofweek

Day of week (Date1)

Return the number of the day during the week (from 1 to 7) from Date1.

### Day of year Dayofyear

Day of year (Date1)

Return the number of the day during the year (from 1 to 365) from Date1.

### Add Day AddDay

(Number1 Add day Date1)

Add Number1 Days to the Date1

### Date difference Datedifference

(Date1 Date difference Date2)

Return Number of day between Date1 and Date2

### Date Date

Date (String1)

Return Date from String1

### Datetime Datetime

Datetime (String1)

Return Date and time from String1

## Logical

### = equal

(Number1 = Number2)

Logical check between Number1 and Number2 :

• 0 if numbers are different
• 1 if numbers are equal

### != notequal

(Number1 != Number2)

Logical check between Number1 and Number2 :

• 0 if numbers are equal
• 1 if numbers are different

### if if

if(Field1, String1, String2)

Logical check if Field1 is true (=1) :

• 0 Return ***String1***
• 1 Return ***String2***

### if null ifnull

(Field1 if null Field2)

Return ***Field2*** if ***Field1*** is null.
It can be used as fallback value

### is null isnull

is null(Field1)

Logical check if Field1 is null

• Null Return 0
• Not null Return 1

### is not null isnull

is not null(Field1)

Logical check if Field1 is not null

• Null Return 1
• Not null Return 0

### > Upper

(Number1 > Number2)

Logical check if Number1 and Number2 :

• 0 if Number1 is not upper than Number2
• 1 if Number1 is upper than Number2

### >= UpperEqual

(Number1 >= Number2)

Logical check if Number1 and Number2 :

• 0 if Number1 is not upper than Number2
• 1 if Number1 is equal or upper than Number2

h3.< Lower

(Number1 < Number2)

Logical check if Number1 and Number2 :

• 0 if Number1 is not lower than Number2
• 1 if Number1 is lower than Number2

### <= LowerEqual

(Number1 <= Number2)

Logical check if Number1 and Number2 :

• 0 if Number1 is not lower than Number2
• 1 if Number1 is equal or lower than Number2

### Like Like

(Field1 Like Field2)

To be defined

### In In

(Field1 In Field2)

To be defined
.
h3. Not In NotIn

(Field1 Not InField2)

To be defined

h3.Between Between

(Number1 Between  Number2 , Number2)

Return 1 (true) if Number1 is between Number2 and Number3 else return 0 (false)

Last modified: Feb 02, 2022

## Feedback

### Was this helpful?

You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.