Top 5 Problems

[pgalvezt]

Hello, I' ve created a table with many values and I tried to get the top 5.

I've attached my example. With others examples works but this one not.

Thanks

[swuehl]

Not really sure what you want to achieve, but you get the TOP5 correctly flagged if you read your Amount in as Money data type, not just as text string, i.e. use this as Money format and first line in your load

SET MoneyFormat='$ #.##0,00;($#.##0,00)';

LOAD  PERSON, DOC, [BB ID], [BB NAME], Money#(Amount) as Amount, AN, AR, [DAY 1], [DAY 2], [DAY 3], RDT  INLINE [

...

];