Algorithms

Arithmetic

+

Addition

a+b

-

Subtraction

a-b

/

Division

a/b

*

Multiplication

a*b

%

Percentage

a/b% is equivalent to a/b*100

a*(1+15%)

^

Exponentiation

a^2 is equal to a*a

Comparison

=

Equal to

a=b

>

Greater than

a>b

<

Less than

a<b

>=

Greater than or equal to

a>=b

<=

Less than or equal to

a<=b

<>

Not equal to

a<>b

Text

&

Concatenation

a&b concatenates two text strings contained in Block "a" and Block "b"

a&”myText” concatenates the string contained in Block "a" with "myText".

When using this operator, the result of the algorithm is a text string therefore you must select the option Text from the Algorithm type dropdown list.

left(text,num_char)

Left substring

Returns the leftmost characters from a text string.

Left(a,4) returns the first four characters of the text contained in Block "a"

right(text,num_char)

Right substring

Returns the rightmost characters from a text string.

Right(a,4) returns the last four characters of the text contained in block "a"

mid(text,start_pos,num_char)

Substring

Returns the specified number of characters from a text string starting from the specified position.

Mid(a,2,4) returns the four characters starting from position 2 of the text contained in block "a"

ABS(number)

Returns the absolute value of a number

ABS(a-b)

AND(logical conditions list)

Returns True if all conditions are True, otherwise it returns False

AND(a>0,b<100) returns True if the value in Block "a" is greater than zero and the value in Block "b" is less than 100

OR(logical conditions list)

Returns True if at least one condition is True. Returns False if all conditions are False

OR(a>0,b<100) returns True if the value in Block "a" is greater than zero or if the value in Block "b" is less than 100

IF(condition,true_value,false_value)

Returns true_value if the condition is True and false_value if the condition is False The condition can be any logical expression

if((a*b)>0,a,c)

if(a>100,”Greater”, ”Lower”)

if(and(a>0,b>0),a*b,0)

Today( )

Returns the current date

today()-a returns the number of days between the date in Block "a" and the current date, provided a date Cube is in Block "a"

today()+a returns a date resulting from the current date plus the number of days specified in Block "a"

dt(column)

Returns the column total. To use this function, the Layout must have an entity set by row

a/dt(a)*100

rt(column)

Returns the row total. To use this function, the Layout must have an entity set by column

a/rt(a)*100

gt(column)

Returns the grand-total. To use this function, the Layout must have an entity set by row and by column

a/gt(a)*100