---
title: Use Cases
description: "### Sum spent hours on project and tasks Customer is big Pharmaceutical company and they are using M-Files as a Project Management solution. They simplified structure have Projects, Tasks and Hour Logging Events, like in Picture 1. ![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-94.png) Their Project…"
url: "https://extensionkit.unitfly.com/documentation/property-calculations-use-cases/"
updated: "2025-05-01"
category: Configurations / Property Calculations
---

# Use Cases

### Sum spent hours on project and tasks

Customer is big Pharmaceutical company and they are using M-Files as a Project Management solution. They simplified structure have Projects, Tasks and Hour Logging Events, like in Picture 1.

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-94.png)

Their Project Managers would like to know at each moment how much time is spent working on a project per each task, as those projects usually takes a bit long. They have configured Calculated properties in two ways:

1. Have information on a **Project** about all hours spent on **Tasks**
2. Have information on a **Task** about all hours spent

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-95.png)

### Configuration of Property calculations

In Picture 2 we can see hierarchy of objects. In M-Files that hierarchy looks like in Picture 3. To configure Extended property calculations, we must be aware of that hierarchy or Parent-Child relationship. In customer cases:

1. Project is parent and Task is child
2. Task is parent and Hour Logging Event is child

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-96.png)
*Picture 3. M-Files implementation structure*

### Sum spent hours on a task

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-97.png)
*Picture 4. Object “Task*“

We will create first rule for summing all hour logging events on tasks. Configuration is shown on Picture 5. We would like that summarizing happen when object is changed (Hour logging event). Parent object is Task and property on task object is Total work (h).

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-98.png)
*Picture 5. Parent object and property*

Children objects are Hour Logging Events (Picture 6) and they have connection to a Task. That’s why Relationship model is from ChildrenToParent and property that connect them is Task (Picture 7).

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-99.png)
Picture 6. Hour Logging Event

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-100.png)
Picture 7. Children objects

Property that we want to sum its Logged Work (h) from Hour logging events. Function that we are using its SUM (Picture 8).

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-101.png)
*Picture 8. Calculation properties and function*

In this case when we add new hour logging event it will be summed and added to related Task object (Picture 9).

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-102.png)
*Picture 9. Calculated property Total work (h) in action*

### **Sum spent hours on a project**

The way to sum all spent hours per project (Picture 10) is same as for Tasks expect now Parent is Project and Children are Tasks.

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-103.png)
*Picture 10. Project*

Property that connect Tasks and Project is property Project on a Task object (Picture 11).

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-104.png)
*Picture 11. Configuration of rule for sum all tasks per project*

The results are seen on Picture 12, how all Total work (h) from Tasks are summarized to Project.

![](https://extensionkit.unitfly.com/wp-content/uploads/2025/05/image-105.png)
*Picture 12. Calculated property in action on Project object*

### Count opened tasks on project

Customer that is using M-Files as Project Management is counting opened tasks per project. Every task is going trough workflow and final state is Closed. In every moment Project Manager can see how many opened tickets they have on each project without opening views.

### Count opened assignments per person

Customer wanted to have information of how many opened tasks are per Person. That information was on a Person object. With customer we have tested different gamification and motivational methods and counting opened assignments was one of them that took effect in productivity.

### Count opened tickets per customer

Customer is using M-Files as a ticketing system with help of [M-Files Email Processor](https://mfilesproducts.wpengine.com/m-files-email-processor/). They are counting how many opened tickets they have per customer and how many total ticket they have. To gain that quick information