Inconsistent top/bottom filter in PAW

[bubidibabadi]

Team,

We use the Top/Bottom filter in PAW to list Favorable and unfavorable P&L lines against budget. We have two views, one that shows Top 5 lines and the other that shows bottom 5 lines. For the Top 5 filter, sometimes the view only shows positive values and ignores negative values. For ex, it would only show 3 P&L lines, instead of 5 because it ignored the P&L lines with negative values. Is this a bug or an expected behavior?

We are using the latest PAW version, 2.0.90.

Thanks.

[Steve Rowe]

What you may find is that it is including zeros in the top count and then suppressing them.

i.e. if you have 10,5,0,0,0,-5,-10
You will only get two numbers in a suppressed top / bottom 5.

If you have a low record count you are better off sorting the list then using top / bottom