What does Consolidate Result do to a C2C formula?

The Consolidate function on the C2C formula page allows you to perform a calculation on every Department and then to sum the results of those calculations and apply that total to just one Department.

WARNING: Consolidating does not remove the data from the source categories so beware of double counting your data. This function is more appropriate for use with non financial categories to calculate KPIs and other metrics.