Hello,
I am facing some problem using suppress zero on TM1.
I have some calculated fields, but when I suppress zero the system ignore this fields and nothing more appears (even with numbers calculated).
And in this example I am on N-level. So it is not a feeder problem.
Anybody have see this already?
Thank you,
JR
Suppress Zero
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Suppress Zero
Why not ?Jorge Rachid wrote:And in this example I am on N-level. So it is not a feeder problem.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Suppress Zero
Because I am on level N.
If there is not a total at my view it shouldn't suppress zero, or not?
Thank you,
JR
If there is not a total at my view it shouldn't suppress zero, or not?
Thank you,
JR
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Suppress Zero
Wim Gielis wrote:Why not ?Jorge Rachid wrote:And in this example I am on N-level. So it is not a feeder problem.
I think the point that Wim was trying to subtly make is this:Jorge Rachid wrote:Because I am on level N.
"You know that idea you have that unfed cells only affect consolidations when zero suppression is on? Yeah, that one. Get rid of it."
If you zero suppress on an unfed, rule calculated, completely N level cell when you have skipcheck on... yes, it is possible that the value will not appear.
Therefore the solution is to turn off zero suppression, right click on the cell and select Check Feeders. Odds are that you will see those two magic words "Not Fed". If so, fix your feeders and try calculating again with zero suppression on.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Suppress Zero
Now I understood.
Thanks for helping again.
Cheers,
JR
Thanks for helping again.
Cheers,
JR