We are trying to use the field a in a way not completely intended. We use the unit conversion table for the usual ways of cases to eaches and pallet quantities. But we are also using it for pulling information to Bartender software for label making for fluid ounces, milliliters, liters and gallons. Since Bartender does not due calculations we have created views based on the conversion table to pull data. This has been working perfectly except for one item we have. And that one needs a decimal in the denominator field.
For almost all items it looks like the following. But we have one that that needs the factor that needs to be 1 and the denominator of 37.5 for ml to fl. oz.
If you've found this thread useful, dive deeper into User Group community content by role