You are here: Home / Extras / Formulas and calculating / Formulas with multi-property-module

Formulas and calculating

Formulas with multi-property-module

Formulas in the multi-object module

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.

pop_up formeleingabe multi

Overview, delete, overwrite and order of calculation

Overview

If you click on the pencil Edit Symbol icon in the column header, you get an overview of all formulas that have been created.

formeluebersicht multi objekt

The formulas of all categories of a module (addresses or properties) are displayed collectively.

Delete

In the overview, you can also delete formulas using the trashcan Trashcan icon 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

Overwrite

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.

Order

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.

Formula Handling in the Multi-Object Module

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.

Example

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 :
    You can use the formula SUM to calculate the sum of several individual fields or, using the curly brackets, fields from all units of the master object.
    Formula structure single object: SUM([Feldname1];[Feldname2];[Feldname3])
    Formula structure master object: 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.
    Example: SUM({[kaufpreis]};[kaufpreis])
    Result: 1,695,000,-
  • MIN :
    The formula MIN can be used to display the minimum value from a pool of values.
    Formula structure single object: MIN([Feldname1];[Feldname2];[Feldname3]) the lowest value from the 3 fields is output.
    Formula structure in the master object: MIN({[Feldname]}) the lowest value of the field from all units is displayed.
    Example: MIN({[kaufpreis]}) The lowest purchase price of all units is calculated.
    Result: 200,000,-.
  • MAX :
    By using the formula MAX, the maximum value can be calculated from a pool of values.
    Formula structure single object: MAX([Feldname1];[Feldname2];[Feldname3])
    Formula structure in the master object: Max({[Feldname]}) to calculate the maximum value of the units of a given field.
    Example: MAX({[kaufpreis]}) The maximum purchase price of all units is calculated.
    Result: 250,000,-.
  • COUNT :
    The number of units can be counted with the COUNT formula function.
    Formula structure: COUNT({[Feldname]}) it is counted how many units are contained in the master object.
    Example: COUNT({[objektnr_extern]}) counts how many units are contained in the root object.
    Result: 3.

Note:

All other formulas that are listed in the Handling formula can also be used for master objects.

Formulas and calculating