This report brings mostly data entered into the Facility management sheet. By leaving the date unselected, the report will use the latest currency rates if there is a need to convert some currency agreements into the selected currency.
By default, the values will come into the agreement’s currency. By choosing a currency into the report, the report will convert the values into the selected currency.
The report is quite heavy to produce, so if you have a lot of agreements in the system and try to run the report without any selections (means you are bringing the data from all agreements), you should save the report to the library first, and run it from there. If you split the report you are also able to run that in the view as well.
The report will bring all agreements (valid or outdated) where "Yes" is selected in the Facility management sheet in the Show agreement in report-dropdown.
Columns explained (if not coming directly from the agreement):
Total lease cost
The total lease cost entered for the lease in the main view of the agreement (Fixed asset + Service).
Total monthly rent/m2 by grained surface
Calculated from the values = (Capital rent + Maintenance rent) x Grained surface area.
Employees last updated
The date when this Number of employees field was last updated. If no value, then it takes the agreement's initial creation date into the report.
Workstations last updated
The date when this Number of workstations field was last updated. If no value, it takes the agreement's initial creation date into the report.
Total monthly rent/square metre
Calculated from the values = Total monthly rent/m2 by grained surface / Square metres
Total monthly rent/employees
Calculated from the values = Total monthly rent/m2 by grained surface / Number of employees
Total monthly rent/workstations
Calculated from the values = Total monthly rent/m2 by grained surface / Number of workstations
Square metres/employee
Calculated from the values = Square metres / Number of workstations
Parking space cost/employee
Calculated from the values = Parking cost per month / Number of workstations