Work with calculation functions in a calculated property

Work with calculation functions in a calculated property

A calculated property has a dynamic value that is based on the values of other properties within the same element. The value of a calculated property is determined by using a configured formula. Calculation functions provide the ability to use logical formulas on the value of a calculated property.

Min() function

The Min() function returns the lowest value from a set of values. The function takes two or more parameters, separated by commas. Each parameter can be a fixed value, a numeric property, an option property, or another function.

Example to ensure a value of zero or below:

min({NumberProperty}, 0)

Max() function

The Max() function returns the largest value in a set of values. The function takes two or more parameters, separated by commas. Each parameter can be a fixed value, a numeric property, an option property, or another function.

Example to determine the required clearance height:

max({Truck height}, {Trailer height})

Avg() function

The Avg() function returns the average value in a set of values. The function takes two or more parameters. Each parameter can be a fixed value, a numeric property, an option property, or another function. 

Example to determine the average:  

avg({Truck height}, {Trailer height})

ValueOrDefault() function

The ValueOrDefault() function returns a predetermined value when a property value is empty. The function takes two parameters, separated by commas, and uses the second value in the calculation if the first is missing. The first parameter is either a numeric property or an option property. The second parameter is a fixed value.

Example to calculate a price incl. VAT:

{Price excl VAT} * (ValueOrDefault({VAT rate}, 1.19))