Filter Ordering of Numeric Values
Hi folks, this is probably a how-to question.
I'm running the following YF:
My data source is a sql statement in postgres db. One column in the statement is this:
-- 0 length precision means no decimal value.
However, when I drop this field into the filter well in report builder, then use format to change filter style to cached list, then update the list values. The sort treats the numeric as a character and sorts in alphanumeric instead of numeric order.
Here's the list of values generated by YF's filter values:
Thanks for you help in advance.