Pie/Donut/Semi-donut Report: Report keeps loading until it presents no output when applying a SUM aggregation because of negative values.Issue This is a particular scenario and is limited to Currency type, for other types we correctly convert to absolute value and pies report work well. When creating a report of type Pie or Donut and using Aggregation, we should be aware of what kind of data the field we want to aggregate holds. This issue happens when you try to Aggregate by Sum, a field of the table and this particular field contains both positive and negative values. As an example, we have the below report: Table: [dmn_demand] Type: Pie/Donut/Semi donut Group by: Any field Aggregation: Sum on "Estimated Run Costs Monthly" Note: In this example, Estimated Run Costs Monthly is a custom field of type Currency. Upon saving and running this report, we can see that it will load for a while: And eventually, it will produce a blank output: CausePie/Donut/Semi-donut represent the percentage distribution of data. In Pie/Donut/Semi donut report, the area occupied by a particular component is proportional to the quantity it represents. So, if we have a combination of negative and positive values, it will not make any sense to represent them in the Pie/Donut/Semi-donut report because these reports represent only magnitude. The components represented by them will not have any direction. For example, let's say we have two groups with revenue £500 and -£500. If we represent them in the Pie/Donut/Semi donut report, both of the component will occupy the same area in the chart. For a person looking into this report, both £500 and -£500 are equivalent but in reality, they are not. This gives the wrong information to the user.We can still make Pie/Donut/Semi-donut report, if all the values in the data are negative (or all are positive) because in this case, we can compare them only through their magnitude as entire data is in the same direction. But for the data having the combination of negative and positive values, representing them in Pie/Donut/Semi-donut does not make sense. In other words, we do not support Pie/Donut/Semi-donut for this type of aggregation and this is why the report will fail to load.ResolutionAs explained in the description we should be aware of the field's data before trying to aggregate by Sum. As this can be a tiresome job, we can simply include an extra filter condition to present the correct data. This will avoid the report to fail. Below, we can see that we are filtering for Estimated Run Costs Monthly, as this field if of type Currency, we are filtering for values that are greater than £0. This will return only positive values and therefore, the right calculation can be made and the report will be shown. In this case, if what we need is the negative values instead, we would look for values that are less than £0.