Allow decimals where the whole number is under a certain amount

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.

One column that is always a decimal that holds the number, and then a Text VC that formats as you wish.

1 Like

You’d have to use Valid if to enforce this. Try:

OR(
  (ABS([_THIS]) < 3),
  (DECIMAL(NUMBER([_THIS])) = [_THIS])
)
1 Like