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 |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |