Negligible value in consolidation
Posted: Wed Oct 18, 2017 2:43 pm
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
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