I have an app where I will be selling items by weight. Often times the weight will only be a half pound. I would like to be able to put the weight in one column and a cost in another column and have a third column record the total.
My problem is the weight column doesnโt seem to be able to accept a number less than 1. When I try putting .5 in the minimal value it changes it to a 1.
In the Valid If formula for column Weight Iโve tried [Weight] >= .5
It says
Arithmetic expression โ([Weight] >= โ.5โ)โ does not have valid input types
The column type for weight, cost and total are number.
Is there a way to be able to input .5 for it to calculate?
Solved! Go to Solution.
Change column type to a DECIMAL with 1 DECIMAL DIGIT
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |