In the "Invoice" column of Falcon's effect settings, you can not only calculate individual rows using the standard operations such as plus and minus, you can also use functions. For example, you can use the function

avg(#1, #2, #3)

to calculate the average of lines #1, #2 and #3. The following table shows you the overview of all available functions. You can always use constants or other lines (#1) as parameters.


Function

Paramter

Syntax

Result

abs()

1 parameter

abs(#1)

Absolute value

acos()

1 parameter

acos(#1)

Arcuscosine

asin()

1 parameter

asin(#1)

Arcussine

atan()

1 parameter

atan(#1)

Arcustangent

avg()

min. 1 parameter

avg(#1, #2, ...)

Average of all parameters

between()

3 parameter

between(#1, #2, #3)

Limitation of a value to max. upper (#3) and min. lower limit (#2)

ceil()

1 parameter

ceil(#1)

Round up

cos()

1 parameter

cos(#1)

Cosine

exp()

1 parameter

exp(#1)

Power to base e

floor()

1 parameter

floor(#1)

Round off

fmod()

2 parameters

fmod(#1, #2)

Remainder of the division (modulus) of #1/#2

log()

1 or 2 parameters

log(#1, #2)

Logarithm to base #2

max()

min. 1 parameter

max(#1, #2, ...)

Maximum of all parameters

min()

min. 1 parameter

min(#1, #2, ...)

Minimum of all parameters

okr()

min. 1 parameter

okr(#1, #2, ...)

OKR average of all parameters (values enter min/max 0/100)

pi()

no parameter

pi()

Pi

pow()

2 parameters

pow(#1, #2)

Power of #1 to the base #2

rand()

parameter optional

rand() oder rand(#1, #2)

Random number between #1 and #2

round()

1 oder 2 parameters

round(#1, #2)

Rounding from #1 to #2 decimal places

sin()

1 parameter

sin(#1)

Sine

sqrt()

1 parameter

sqrt(#1)

Square root

sum()

min. 1 parameter

sum(#1, #2, ...)

Sum of all parameters

tan()

1 parameter

tan(#1)

Tangent

Did this answer your question?