I am trying to route to a folder which has a template field containing a number field value. I want to route to the folder with the minimum value in that field. I search for the various target folders successfully, then sort by ascending and select the first value, hoping to get the one with the minimum value in the field. The sort ignores any field values with zero in them???? (A zero would be acceptable). The field is a number field.
I then tried an approach using a token calculator to find the minimum value and select that, but the behavior is the same; it seems to ignore any entries with a zero in the field, but otherwise works fine?
Any ideas why it is ignoring zero as a minimum value?