Dyn. User Functions

Dynamic user functions allow you to create formulas that can be reused in formula fields and the Formula Editor. This is useful when you have a calculation (simple or complex) that is used many times in several formulas because you can select this formula instead of needing to know the right formula and enter it directly into the formula field.

For example, to calculate the area of a circle, you can create a Dyn. User Function "CIRCLEAREA" with formula "%1^2*PI" and then in the formula fields, replace the placeholder with the variable RADIUS: CIRCLEAREA(RADIUS). Without the Dyn. User Function, you would need to enter RADIUS^2*PI each time. Additionally, with the quick access to the Dyn. User Functions in the formula fields, you can easily select the functions from the list and update the placeholders.

Note

To ensure proper calculations, Dyn. User Functions must be named differently than variables.

Feedback
Submit feedback for this page .