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))