If I want numbers less than say 3 to allow decimals but if its bigger than 3 it must be a whole number, how would I do that? they can be up to around 300-400 and can only have 2 decimal places if lower than 3.
Solved! Go to Solution.
You’d have to use Valid if to enforce this. Try:
OR(
(ABS([_THIS]) < 3),
(DECIMAL(NUMBER([_THIS])) = [_THIS])
)
One column that is always a decimal that holds the number, and then a Text VC that formats as you wish.
You’d have to use Valid if to enforce this. Try:
OR(
(ABS([_THIS]) < 3),
(DECIMAL(NUMBER([_THIS])) = [_THIS])
)
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |