Allow decimals where the whole number is under a certain amount

Austin
Participant V

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 Solved
0 2 133
1 ACCEPTED SOLUTION

Steve
Participant V

Youโ€™d have to use Valid if to enforce this. Try:

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

View solution in original post

2 REPLIES 2

Bahbus
Participant V

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

Steve
Participant V

Youโ€™d have to use Valid if to enforce this. Try:

OR(
  (ABS([_THIS]) < 3),
  (DECIMAL(NUMBER([_THIS])) = [_THIS])
)
Top Labels in this Space