Validating a list of numbers
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