Hello,
I have data like this:
| ID | Title | Estimate | Actual | Parent | other fields... |
|---|
| 1 | A | 10 | 12 | | |
| 2 | B | 5 | 10 | 1 | |
| 3 | C | 5 | 2 | 1 | |
| 4 | D | 3 | 5 | 2 | |
| 5 | E | 2 | 5 | 2 | |
I need to get statistics on Estimate and Actual and the issue is that data is already calculated up. 4 and 5 task times sum is in task 2 and 2 and 3 is in task so if I am filtering by other fields and using sum(actual)-sum(estimate) I am getting wrong results. How could I solve this?
