Have you ever wondered about the total value of your fixed assets, the range of purchase prices across individual cost centers, or the average price of the vehicles in your fleet? You can view these figures in just a few steps.
Important:
You can evaluate numeric and currency fields. To get meaningful results, make sure these fields are filled out for all your assets.
First, open your object list and filter it by the criteria you want. For example, you can filter by a specific cost center or by vehicles at a particular location. The figures are calculated based on the objects currently displayed after filtering.
Important:
Make sure that the Purchase Price field (or any other numeric/currency field relevant to you) is visible in your list view. In this article, we explain how to do that.
To the right of every numeric or currency field (in our example, the Purchase Price), you will see a small 1-2-3 icon.
Click the icon to open an info box. It shows the sum of the values for your filtered objects. Below that, you’ll see the smallest and largest values, as well as the average.
You love this feature and are looking for more use cases? Here are a few more:
Find expensive outliers
Filter by category, e.g. vehicle fleet
Currency field: Purchase Price
When combined with the average price, the maximum value highlights unusual figures, allowing you to check these items specifically for data entry errors or, for example, optional extras.
Average repair costs per device type:
Filter by category (e.g., notebooks)
Currency field: Repair costs
Purpose: To identify models/series with conspicuously high repair costs
Replacement value per location, warehouse or branch
Filter by a location or similar criteria
Currency field: Replacement value or purchase price
Purpose: To estimate the insurance or risk value of the location
Love this feature and looking for more ways to use it? You can also analyze dropdown, room, person, user, and location fields. Find out more in How can I analyze dropdown columns?