Last Updated: 06 Apr 2018 12:55 by ADMIN
Created on: 21 Jul 2017 08:49
Category: TreeList
Type: Bug Report
The Aggregate sum value in Treelist does not calculate the sum properly
The agregate sum value shown in the bottom of the TreeList columns displays bigger sum than the actual one (it seems that the child items values are also taken into consideration).

Steps to reproduce:
1. Open

2. Check the sum shown in the Population column

Actual: It shows 10,702,470,081.00

Expected: It should be 6,464,732,588.00
1 comment
Posted on: 06 Apr 2018 12:55
Actually the described behavior is by design and since the appearance of the UI component. The TreeList aggregates based on the resolved data source items. For example, for Bulgaria, we have the following data:

Bulgaria - 7,621,337.00

Sofia - 1,267,608.00

Plovdiv - 380,694.00

Varna - 356,847.00

The total for Bulgaria which is displayed in the footer is 2,005,149.00,  which reflects the three cities. However when calculating the parent level - Europe the values from the resolved data source will be taken, which includes the value of Bulgaria alongside with the cities. The logic is functioning in this manner since 2011. If we alter it, this will lead to a breaking change for the huge part of the customers and we want to unwant it.