We are having an issue where we are perfoming a relative proportional spread to data and some columns that we expect to zero out are getting data such as 2.15E15.
Is there a way to set precision down a hair to take care of this? Suppressing zeros after doing the data spread causes the view to show lines that look like all zero.
Data Spreading Issues
-
PlanningDev
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Data Spreading Issues
You can change spreading precision by adjusting the parameter in tm1s.cfg
However in this instance it might be better to zero out via TI, or use the spreading clear method or repeat leaves zeros to completely zero out to small residual cell values.
However in this instance it might be better to zero out via TI, or use the spreading clear method or repeat leaves zeros to completely zero out to small residual cell values.