Metrics based on hidden fields

When I create a metric, and then I set the visibility of the underlying field to ‘do not include’, I get strange error messages in the GUI.

Basically what I have is a table with a field article_number and article_price (in cents). I don’t want to bore my users with those two fields since people tend to make mistakes when some numbers are in cents;

I only want them to see the metric turnover in euro’s, which would be SUM(article_number * article_price / 100).

Is there anything special I need to do to hide the underlying fields, and only give them the metric to work with?

This is on Metabase 0.25.2 on a Mac.

1 Like