Dynamic

Conditional Value

ConditionalValue({Variable}, {Condition1}, {Result1}, {Condition2}, {Result2}, ... , {DefaultValue})

Compares a variable to a set of condition-result pairs and returns the corresponding result when the variable matches a condition (also known as a "switch" function). If the variable does not match any of the conditions, the default value is returned.

Input: ConditionalValue({A}, “yes”, 10, “no”, 20, 0)

Result: If yes is the provided variable, 10 is returned.

Subtract

{FieldA}-{FieldB}

Difference between two values.

Input: 9 - 6

Result: 3

Sum

{FieldA}+{FieldB}

Sum of two values.

Input: 2 + 3

Result: 5

Text Analysis

TextAnalysis({Variable},{Expression1},{Result1}, {Expression2},{Result2},{DefaultValue})

Compares a variable to a set of expression-result pairs and returns the corresponding result when the variable matches an expression (also known as a "switch" function). If the variable does not match any of the expressions, the (DefaultValue) is returned.

Input: TextAnalysis("Tonkean", "Tonkean", "test1", "123", "test2", "test3")

Result: test1