All Collections
Effects
Effects functions in Falcon
Effects functions in Falcon

Learn which functions you can use in the effects.

Finn Wesseloh avatar
Written by Finn Wesseloh
Updated over a week ago

Which permissions do I need for editing?

HUB OWNER


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.


To add functions, carry out the following steps:

  • Switch to administration

  • Select "Budgeting"

  • Select "Edit this budgeting" via the corresponding cogwheel


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


Click here to learn how to set up okr's in detail.

Did this answer your question?