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.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.Expressions are node names with logical or mathematical operators that specify the operation to be performed.
- 3.References are the node names that refer to the nodes from the model and contain those values.
- 4.Constant refers to a value or a number that does not change.
Let us first see the logical, mathematical and other operators.
OPERATORS | DESCRIPTION |
---|---|
&& | Logical AND |
|| | Logical OR |
OPERATORS | DESCRIPTION |
---|---|
() | Parenthesis |
+, - | 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.
Note:
- 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.In function syntax, - > number refers to the numerical result of the performed function.
- 3.valueN? refers to the unlimited 'N' number of arguments that a function can accept.
- 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.
- 5.Text in blue represents the keywords in formula functions of ValQ.
Last modified 1mo ago