Page 1 of 1

Negligible value in consolidation

Posted: Wed Oct 18, 2017 2:43 pm
by kenship
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

Re: Negligible value in consolidation

Posted: Thu Oct 19, 2017 8:36 am
by BariAbdul
Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks

Re: Negligible value in consolidation

Posted: Wed Nov 15, 2017 5:36 pm
by Duncan P
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.