Hi, I have a simple report cube which:
1. Has no rule
2. Values (rounded to 2 decimal places by TI) are put in by a TI process from another cube.
Issue: Some consolidated cells show a negligible value (e.g. 0.000000000000013) when the children cells are added to a perfect $0.00 and therefore should be suppressed.
Is there any solution to this? Can I use a rule to round a consolidated cell without using too much resource?
Thanks.
Kenneth
Negligible value in consolidation
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Negligible value in consolidation
Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks
https://goo.gl/PT54d8 Thanks
"You Never Fail Until You Stop Trying......"
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Negligible value in consolidation
If you are interested in why it happens then have a read of this.
The effect is magnified in consolidated numbers and the level of error increases the more leaf numbers are involved.
The effect is magnified in consolidated numbers and the level of error increases the more leaf numbers are involved.