When you analyze your production indicators, you may observe differences between the amounts displayed in your widgets and those in your project lists. These differences are normal and are explained by distinct calculation logics between these two tools.
This article presents the main cases where these differences appear, to help you interpret your data correctly.
Case 1: Filtering by Business Unit
What happens?
When you filter your data by Business Unit, the widgets and project lists may display different amounts because they apply distinct calculation logics.
How do the widgets filtered by BU work?
Widgets like "Produced MB by BU" or "Produced MB over the VAT excl. period" calculate only the distributed production amounts on the selected Business Unit.
Concrete example:
• Project X: 10,000 € Gross Margin
• Distribution: 60% BU A / 40% BU B
• Progress of 50% over the period
Result in the widgets:
• Widget "Produced MB" filtered on BU A → 3,000€
• Widget "Produced MB" filtered on BU B → 2,000€
The widgets perform a sum of the distributed production amounts on the BU, prorated to the progress achieved.
How do the project lists filtered by BU work?
The project lists display all projects that contain at least one distribution on the selected Business Unit, with the total production amount of the project.
Concrete example (same project):
• Project X: 10,000 € Revenue
• Distribution: 60% BU A / 40% BU B
• Progress of 50% over the period
Result in the lists:
• List filtered on BU A → displays 10,000€
• List filtered on BU B → displays 10,000€
To go further
Key takeaway
The differences between widgets on Revenue/Gross Margin produced and project lists are explained by distinct calculation logics: the widgets filtered by BU calculate the production prorated to the gross margin distributed to each Business Unit, while the lists display the projects containing at least one distribution on the selected BU. Check the indicator "Check MB" in your lists to ensure that the gross margin distribution among your BUs compared to the project's gross margin is correct.
