Skip to main content

Custom Formulas for Calculated Inputs in Object Settings

How to use the Custom function to write custom formulas with up to two parameters in the calculated inputs section of Object settings.

Updated today

Introduction

This article explains how to use the Custom function for calculated inputs in the admin panel Object settings. Custom formulas let you define your own equations using up to two parameters.


1 Parameters and Variables

Custom formulas support up to two parameters, selected from the Parameter1 and Parameter2 dropdown menus.

Parameter1 and Parameter2 dropdown menus in Object settings

In the formula, these parameters are represented by the variables p1 and p2 respectively. For example, a formula that divides Parameter1 by 1000 would be written as p1/1000.

Example of a custom formula using p1 divided by 1000

Formulas follow standard mathematical rules and can be fully adapted to your specific needs. The following operators are available:

Operator

Function

Example

+

Addition

p1 + p2

-

Subtraction

p1 - 100

*

Multiplication

p1 * 0.125

/

Division

p1 / 1000

( )

Brackets (grouping)

(p1 + p2) / 2

1.1 Example Formula

The image below shows an example formula with the order of operations marked step by step:

Example formula with marked order of calculation steps

πŸ’‘ Tip: For more information about other available input functions such as Linear, P1+P2, and Linear++, see Configuration of inputs in Object settings.

Did this answer your question?