I’m of course talking about those of us with little to no understanding of mathematics. Luckily, there is still a field in Dynamics that caters to our needs – the calculated column.

The administrators will need an overview of the number of games won, lost, and drawn, preferably in percentage. Using calculated columns, they will be able to see the percentage of each category without having to bring out their calculator and trying to remember how to calculate percentages.

We created three columns following the same structure:

In the administrator app the administrators can with i quick glance on the screen see how the team is doing, as well as use it in their PowerBI report.

Sadly, calculated columns will be a thing of the past at some point, and the functionality will be sorely missed.