# Why is my numerical column only showing 0 or 1?

**URL:** <https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85>\
**Category:** Modeling\
**Created:** [May 31, 2024, 7:04pm UTC](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85 "2024-05-31T19:04:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![conner](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conner/32/11_2.png) [@conner](https://community.omni.co/u/conner)\
**Post date:** [May 31, 2024, 7:04pm UTC](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85/1 "2024-05-31T19:04:48Z")

</div>

This is a frequent problem with integer math (e.g. dividing two whole numbers). We’re looking to add helpers for these in the model, but this can also be avoided by multiplying by 1.0 to cast the result to a decimal. For example:

```auto
(${order_items.count} / ${order_items.order_count}) * 1.0

```