Page 1 of 1

Data Spreading Issues

Posted: Mon Feb 21, 2011 3:37 am
by PlanningDev
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.

Re: Data Spreading Issues

Posted: Mon Feb 21, 2011 4:25 am
by lotsaram
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.