I am trying to divide two columns:

([Location_Total_Count_Out_By_Location_Category] / [Location_Total_Inventory_Count_By_Location_Category])

It doesn’t give me a percent. It gives - 0%

I am trying to divide two columns:

([Location_Total_Count_Out_By_Location_Category] / [Location_Total_Inventory_Count_By_Location_Category])

It doesn’t give me a percent. It gives - 0%

There are several things that it could be.

- 0% is a percent. Are either or both of the values 0?
- Is the output column setup as a percent?
- How many decimal places are allowed? I believe that 0 is the default.
- Are the two input columns setup as numbers?

ok. So the values are not “0” for any of them - so that can’t be it.

Output column is - type = “percent”

I put - no decimal places ( i tried 2 as well - still nothing)

the two input columns are type = “number”

Are these configurations correct?

Try:

```
([Location_Total_Count_Out_By_Location_Category] / DECIMAL([Location_Total_Inventory_Count_By_Location_Category]))
```

When dividing two *Number* values, the result will always be a *Number* value. *Number* values have no decimal point, so any fractional component is lost. To avoid this, convert one or both *Number* values to *Decimal* by using the *DECIMAL()* function as above, or by multiplying the *Number* by 1.0.

2 Likes

Steve- that worked. THANKS again!

1 Like