### Operators ### And

Operands:

• Operand1 : any
• Operand2 : anyThe input operands are converted to boolean. See the Convert To Boolean (Object) method for the conversion logic
• Output Type: Boolean
``Example: 3 > 2 and 2 > 1``

### Array

Prefix operation that create an object array

### Operand Count: 0 to infinite

• Operand Type: Any
• Output Type: Array
``Example: @(1, 2, 3, 4, 5)``

### Avg

Prefix operation that return the average of a set of numbers

• Operand Count: 0 to infinite
• Operand Type: Number, if the operand count is 1, it can be an array
• Output Type: Number
``Example: avg(1, 2, 3, 4, 5) or avg(@(1, 2, 3, 4, 5))``

Note: null value will not be counted, therefore avg (null, 2, 2, 2) should be 6/3 = 2 not 6/4 = 1.5; It will return null if the count is 0.

### Round

Prefix operation that return the Round of decimal numbers

• Operand 1: Decimal number will be rounded
• Operand 2: Number of digits
• Operand Type: Number
• Output Type: Number
``Example: Round(1.2323) = 1 Round(4.2312321, 2) = 4.23``

### Coalesce

Prefix operation that return the first non null operand

• Operand Count: 1 to infinite
• Operand Type: any
``Example: Coalesce(null, 1, 2, 3) will return 1``

### CreateDate

Prefix operation that create an date

• Operand Count: 3
• Operands year : Numbermonth : Numberday : Number
• Operand Type: int
• Output Type:DateTime
``Usage: CreateDate(2018, 1, 31)``

### Date

Prefix operation that convert input to date. The operand is converted to text first and parsed to a datetime object

• Operand Count: 1
• Operandsinput : anyOutput Type: DateTime

### Divide

Infix operation that perform divide

• Operand Count: 2
• OperandsOperrand1 : NumberOperrand2 : Number
• Output Type: Number

### Equal

Infix operation that perform an equal check

• Operand Count: 2
• OperandsOperrand1 : NumberOperrand2 : Number
• Output Type: Number

### Format

Prefix operation that will take an input and C# format string and produced a formatted string

### GreaterEqual

Infix GreaterEqual operation.

• Operand Count: 2
• OperandsOperand1 : anyOperand2 : any
• Output Type: Boolean
``Usage: 3 >= 2``

### GreaterThan

Infix GreaterThan operation.

• Operand Count: 2
• OperandsOperand1 : anyOperand2 : any
• Output Type: Boolean
``Usage: 3 > 2``

### If

Prefix if operation

• Operand Count: 2 or 3
• Operandscondition: anyresult when true: anyresult when false, if omitted, will be default to null: any
• Output Type: any
``Usage: if( 3 > 2, "OK", "No")``

### IsBlank

Prefix operation to check if the input IsBlank

• Operand Type: any
• Null, empty string and string with only white space are considered as blank

### Left

Prefix operation that return the substring of the input text with the specified length and start index of 0

• Operand Count: 2
• Operandsinput: stringcount: Number
• Output Type: string
``Usage: Left("test", 1) should return "t"``

### Len

The Len function returns the length of a given text string as the number of characters. Len will also count characters in numbers, but number formatting is not included.

``Usage: Len(text)``

### LessEqual

The LessEqual to operator (<=) returns TRUE if the first value is less than or equal to the second value.

• Operand Count: 2
• OperandsOperand1: anyOperand2: any
• Output Type: Boolean

### LessThan

The LessEqual to operator (<) returns TRUE if the first value is less than the second value.

• Operand Count: 2
• OperandsOperand1: anyOperand2: any
• Output Type: Boolean

### Max

The Max function returns the largest numeric value in a range of values.

• Operand Count: 1 to infinite
• Output Type: Number
``Max(number1, [number2], ...)``

### Min

The Min function returns the smallest numeric value in a range of values.

• Operand Count: 1 to infinite
• Output Type: Number
``Min(number1, [number2], ...)``

### Mod

Infix operation that perform an mod operation

• Operand Count: 2
• OperandsOperrand1 : NumberOperrand2 : NumberOutput Type: Number

### Multiply

Infix operation that perform an multiply operation

• Operand Count: 2
• OperandsOperrand1 : NumberOperrand2 : Number
• Output Type: Number

### Or

Infix OR operation.

• Operand Count: 2
• OperandsOperand1 : anyOperand2 : any
• Output Type: Boolean
``Usage: 3 > 2 or 2 > 1``

### Plus

Infix operation that perform an plus operation

• Operand Count: 2
• OperandsOperrand1 : NumberOperrand2 : Number
• Output Type: Number

### Power

Infix operation that perform an power operation

• Operand Count: 2
• Operandsbase : Numberoperand : Number
• Output Type: Number