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], ...)

Minus

Mod

Infix operation that perform an mod operation

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

Month

MonthName

Multiply

Infix operation that perform an multiply operation

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

Negative

Not

NotEqual

Now

Or

Infix OR operation.

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

PadLeft

PadRight

Pi

Plus

Infix operation that perform an plus operation

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

Positive

Power

Infix operation that perform an power operation

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

Right

ShortMonthName

Text

Today

Year

IN THIS

Did this answer your question?