You are here: Home / Extras / Formulas and calculating / Formulas with multi-property-module
Formulas with multi-property-module
Formulas and calculating
You are here: Home / Extras / Formulas and calculating / Formulas with multi-property-module
Formulas and calculating
With the multi-object module you can enter special formulas for master objects when entering formulas. This enables you to use values from the units for calculation in the master object. For example, you can calculate the value of all units or the highest or lowest price of units in the master object.
To define a formula for a master object, select the checkbox next to “Alternative formula for master objects”. This activates the second field in the formula popup to store a separate formula for the master object. To use unit data in the calculation, insert curly brackets {} before and after the field you want to calculate from the units. Examples can be found here .
There is another special feature of the formula field for master objects, because if you do not enter a formula in this field, no calculation is performed in the master object. The formula from the upper formula field is then also not exploded.
If you click on the pencil icon in the column header, you get an overview of all formulas that have been created.
The formulas of all categories of a module (addresses or properties) are displayed collectively.
In the overview, you can also delete formulas using the trashcan icon. Indirectly, formulas are deleted when you delete a field that is used in a calculation. A corresponding warning appears when you delete a field: “The field is used in formulas for the following fields: xyz When the field is deleted, the formulas are also removed
If a value is already stored in a field for which a formula has been defined, you can have this value overwritten. You can make this setting using the editing pen next to the heading of the formula column. This can be specified for each individual formula. Fields that are overwritten are grayed out and cannot be edited
By default, the setting for the system formulas is applied.
In some cases a calculated result is used in another formula. Then the order of calculation is important. In general, system formulas are always calculated first, followed by the individually entered ones in the order in which they appear in the overview list. You can change the order by making an entry in the “Pos” column.
As already described in the upper part, you can include unit values in the calculation for these separate formulas. You can use the curly brackets to bracket individual fields or entire calculation functions and thus determine that only values from the units are taken into account for the calculation.
The following example explains what the different formulas display as results.
Prerequisite: Trunk object with three units.
Prime object: Purchase price 1.000.000,-
1. Unit: Purchase price 250.000,- living room: 1 bedroom: 3 bathrooms: 1
2. Unit: Purchase price 245.000,- living room: 1 bedroom: 2 bathrooms: 1
3. Unit: Purchase price 200.000,- living room: 1 bedroom: 2
SUM([Feldname1];[Feldname2];[Feldname3])
SUM({[Feldname]})
For example, you can use the totals formula in the master object to calculate the sales value of the master object with all its units.SUM({[kaufpreis]};[kaufpreis])
MIN([Feldname1];[Feldname2];[Feldname3])
the lowest value from the 3 fields is output.MIN({[Feldname]})
the lowest value of the field from all units is displayed.MIN({[kaufpreis]})
The lowest purchase price of all units is calculated.MAX([Feldname1];[Feldname2];[Feldname3])
Max({[Feldname]})
to calculate the maximum value of the units of a given field.MAX({[kaufpreis]})
The maximum purchase price of all units is calculated.COUNT({[Feldname]})
it is counted how many units are contained in the master object.COUNT({[
objektnr_extern]})
counts how many units are contained in the root object.Note:
All other formulas that are listed in the Handling formula can also be used for master objects.