Blocks

Short Description

Block Definition: Calculation Expression - used to make more complex arithmetic calculations and formulas such as it can be done in Excel. Each Block has Result field, where the user defines the end formula of calculation in table/row Excel naming convention.

Parameters description:

Tooltips

Result of Calculation block returns - the result on Block's work output is the Variable of numerical(Integer, Double or Date and Time(Long)) type. Fill up this field obligatory.


Flows: - this block has finished its work and the flow is over. The block has only one flow.

Main Description


Main Definition:
Block returns result of calculation on output. The block receives mathematical formula in "Result" field.

Block support following operations:
"-" Subtraction.
"+" Addition.
"/" Division.
"*" Multiplication.
"power(X, Y)" Returns the value of X to the power of Y.

"%" Modulus.
"sin(X)" Returns the sine of expr, where expr is assumed to be in radians.
"cos(X)" Returns the cosine of expr, where expr is in radians.
"tan(X)" Returns the tangent of expr, where expr is assumed to be in radia.
"ln(X)" Returns the logarithm base e of expr. If expr is not in the domain, an error will occur.
"atan(X)' Returns the angle in radians between -pi/2 and pi/2 whose tangent is expr.
"acos(X)" Returns the angle in radians between 0 and pi whose cosine is expr.
"asin(X)" Returns the angle in radians between -pi/2 and pi/2 whose sine is expr.
"exp(X)" Returns Euler's number e raised to the power of a double value.
"min(X, X)" Returns the minimum between expr1 and expr2.
"max(X, X)" Returns the maximum between expr1 and expr2.
"sqrt(X)" Returns the square root of expr. If expr is not in the domain, an error will occur.
By clicking on Column or Row is possible to Add new Column/Row or to delete it.

See the following example, where the current spread from Last Tick is calculated: