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.
Inconsistent top/bottom filter in PAW
-
- Posts: 11
- Joined: Tue Jul 23, 2019 7:19 pm
- OLAP Product: TM1
- Version: 10.2.2, Planning Analytics wit
- Excel Version: 2010
Inconsistent top/bottom filter in PAW
Regards,
bubidi.
bubidi.
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Inconsistent top/bottom filter in PAW
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
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
Technical Director
www.infocat.co.uk
www.infocat.co.uk