TM1 Forum

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.

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