A value format controls how a numeric result appears. It leaves the SQL value available for arithmetic and sorting. Use decimal_2 for the revenue measure when the request needs two decimal places without assigning a currency to the fixture. Multiplying the SQL by one hundred to display cents changes the metric itself. Display settings must not be used to repair an incorrect calculation.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Apply a display format without changing stored values.