Why Dynamics Roll-up Fields are Undervalued!
Microsoft Dynamics 365 for Sales, and generally the platform, comes with some wonderful, under-utilised functionality.
Only recently have our customers started to scratch the surface with calculated and roll-up fields to assist in reporting and analytics. The following examples show scenarios for event management and event value as well as account management and customer value.
Event Management:
In the above example, the customer are using roll-up and calculated fields to analyse the value of the campaign, from Lead and Opportunity relationships and response management based on the Event Response relationship.
From this the customer can deduce how much revenue the event has generated, the cost of the event versus the revenue and manage capacity versus attendee numbers.
Account Management:
The above example, rolled up on an account record, calculated from related opportunities, shows account managers or business development managers the accurate, up to date financial information about that customer.
This has allowed the customer to make quick, informed decisions about their customers as well as identify the more valuable customers to the business.
Using roll-up or calculated fields allows for a greater confidence in data and can only help you with key business decisions. Leveraging the filter and hierarchy options within the calculations will allow for complex and rich roll-ups and are available for all different scenarios from administration to sales & marketing.
Let us know your examples of where Dynamics roll-up or calculated fields have benefited your business!


