### Title

Validating a list of numbers

### Post

Hello all,

I am trying to validate a list of numbers, but there are specific parameters that I want approved. The list needs to be validated so that it only allows numbers in counting order (i.e. 1,2,2.5,3,3.1,4,6,etc.) as that list shows it needs to allow for decimal usage. It also needs to allow repeat numbers. If it can validate all those things, that would be useful. I thought I could manage it simply with a validation by calculation of:

*number* < GetNthRecord ( *number* ; Get ( RecordNumber ) + 1 )

(with *number* being the field validated) But this evaluates false at incorrect times. I'm unsure what to use to get this working. Please let me know if you have any insight to this particular situation.

Thanks so much

Make sure that your field is defined to be of type number, not text and that any calculation fields have Number specified as a result type.

And if each of these numbers are in a different record as appears to be the case, they can be sorted into a different order or unsorted quite easily and this will affect your validation and in fact, given how easy it is to sort the values correctly into this order, I'm not sure that I understand the user scenario where you'd be needing this validation to take place.