Round off Average In Metabase

Hi Everyone ,

Please I am trying to round off average calculation to 2 decimal places without editing the SQL. The reason I do not want to edit the SQL is because when I edit the SQL the filters on the dashboard don't apply anymore to edited SQL questions.

Please kindly assist.

Hi @Uforo
You can use expressions (https://www.metabase.com/docs/latest/users-guide/expressions.html) or formatting (https://www.metabase.com/docs/latest/users-guide/05-visualizing-results.html#column-formatting-options), or use SQL with variables (https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html)