Formula
A method to make a calculation in Cost Settlement, in order to divide (service) costs among various parties.
A maximum of two formulas can be linked to each
CSP line. Example: 70% of the heating costs will be divided based on meter readings, whereas 30% will be split based on the m3 of the rentable unit. It is also possible to define a formula that uses the counter readings that are linked to the counter (gas / water / electricity / ….) of that rentable unit (or group of rentable units).
In your formula, you can specify a field of one of the following business objects: space usage, rentable unit (RU), contract or contract line. This field is the basis for the cost distribution. Example of a cost distribution field: Net area of the space usage. You can influence / correct the figures from this field by specifying a second field that serves as a (multiplication) correction factor (the use of a factor field is optional). The values of that field will be used to multiply the values of the cost distribution field.
Formula: <Value from Space usage field> * <value from space usage correction factor field> = the share of this space (usage) in the total distribution key.
If a space is partially empty, the calculation is:
(<Value from Space dimensions field> * <value from space dimensions correction factor field>) - (minus) (<Value from Space usage field> * <value from space usage correction factor field>)
If there is no space usage or a space is not rented out, you must also specify a field and correction factor field (optional) of the Space dimensions business object in your formula:
<Value from Space dimensions field> * <value from space dimensions correction factor field> = the share of this space in the total distribution key.
| In this case, it is about vacancy and these costs usually go to the lessor. However, these can also be divided among the other lessees (if the Charge costs to lessor at vacancy option is set to Yes; see Cost settlement profile line fields). |