Formula Functions

ValQ supports many traditional user-friendly functions that allow you to create complex models. You can use these functions under Configuration in the Model Tab while writing formulae for the Formula type nodes to build/edit the models.
A formula can contain functions, expressions, references and constants.
  1. 1.
    Function takes in one or more values and performs a defined operation to return a result. Every function is defined with a keyword and a specific syntax that is to be followed.
  2. 2.
    Expressions are node names with logical or mathematical operators that specify the operation to be performed.
  3. 3.
    References are the node names that refer to the nodes from the model and contain those values.
  4. 4.
    Constant refers to a value or a number that does not change.
Let us first see the logical, mathematical and other operators.

Logical Operators

Logical AND
Logical OR

Mathematical and Other Operators

+, -
plus, minus(-1) sign
*, /
Multiplication, Division
+, -
Addition, Subtraction
==, !=
Equal to, Not equal to
>, >=
Greater than, Greater than or equal to
<, <=
Less than, Less than or equal to
In the upcoming sections, we'll explore the different functions along with relevant examples for a better understanding.
  1. 1.
    The arguments with a ? in the function syntax are optional arguments based on the use-case. When there is no optional argument, a function performs according to its default settings.
  2. 2.
    In function syntax, - > number refers to the numerical result of the performed function.
  3. 3.
    valueN? refers to the unlimited 'N' number of arguments that a function can accept.
  4. 4.
    Node references have been enclosed within square brackets, and each node is shown in a different color scheme for easy comprehension.
e.g. Sales node is represented as [Sales] and so on. In ValQ, along with colour scheme, the complete lineage of nodes are displayed when you choose them from the pop-up.
  1. 5.
    Text in blue represents the keywords in formula functions of ValQ.