Metabase Version. 0.43.1
Numeric column type become a data column type.
When using the QB, working with a transaction records dataset, I create a Distinct(id) column, SUM(amount) column, SUM(quantity) column, AVERAGE(amount) column, and AVERAGE(quantity) column. I adjust the column name and format the numbers (such as amount of decimal places) as expected. Then, when I add an additional summarization, a custom expression equal to SUM(amount) / SUM(quantity) which I call Average Value, the AVERAGE(amount) column becomes a date type. This behavior only occurs when I add the custom expression and goes away (the AVERAGE(amount) column returns to being a numeric type) when I remove the custom expression.