Average or Sum on Invalid Data Type
From Alchemex
Home > Average or Sum on Invalid Data Type
Average or Sum on Invalid Data Type
Cause: You are using a Sum or Average Aggregate Function on a Display Column which is of a data type that cannot be Averaged or Summed. Usually this will be when attempting to use the aggregate against a Character or Date data type.
Resolution: Do not use the Aggregate function against the data type in your chosen Display Column.