Syntax Error or Access Rule Violation detected by database (Unknown column 'avg_of_xxxxxxxxxx' in 'order clause') or (Unknown column 'avg_of_xxxxxxxxxx' in 'order clause')Issue When using the 'Sum' Aggregation in a report, one may run into the error: Syntax Error or Access Rule Violation detected by database (Unknown column 'sum_of_xxxxxxxxxx' in 'order clause') A similar error can be observed when using the 'Average' Aggregation Syntax Error or Access Rule Violation detected by database (Unknown column 'agerage_of_xxxxxxxxxx' in 'order clause')CauseOne cause for the observed errors is that the selected value in the 'Aggregated field" is not an actual field. Ex: "SLA definition -> SLA Definition fields" is not a field.ResolutionYou will need to drill down one or more times in the "Aggregation Field" until a field is selected. Ex) SLA definition -> SLA Definition fields -> Duration