https://forums.autodesk.com/t5/autocad-forum/table-cell-references-and-calculations-default-whole-numbers/m-p/11937095#M37132 <P>I'm building an electrical panelboard drawing with tables holding the load information.&nbsp; From those loads I'm calculating capacity information using functions within the table.&nbsp; But very oddly, when referencing cells from other tables within the drawing, and the calculated sum turns out to be an integer, the data type for the calculated cell automatically seems to default to a data type of "Whole Number", even if the cells original data type was something else.&nbsp; This quite aggravating as the trailing zeros in the calculated value are required to display accuracy.</P><P>&nbsp;</P><P>This does not seem to be the case if all calculations use cells that reside in the same table as the calculations.&nbsp; It only seems to happen when referencing cells from other tables.&nbsp; Any thoughts on how to address the lack of trailing zeros?</P> Tue, 02 May 2023 18:58:57 GMT brad_wojcik 2023-05-02T18:58:57Z https://forums.autodesk.com/t5/autocad-forum/table-cell-references-and-calculations-default-whole-numbers/m-p/11937095#M37132 <P>I'm building an electrical panelboard drawing with tables holding the load information.&nbsp; From those loads I'm calculating capacity information using functions within the table.&nbsp; But very oddly, when referencing cells from other tables within the drawing, and the calculated sum turns out to be an integer, the data type for the calculated cell automatically seems to default to a data type of "Whole Number", even if the cells original data type was something else.&nbsp; This quite aggravating as the trailing zeros in the calculated value are required to display accuracy.</P><P>&nbsp;</P><P>This does not seem to be the case if all calculations use cells that reside in the same table as the calculations.&nbsp; It only seems to happen when referencing cells from other tables.&nbsp; Any thoughts on how to address the lack of trailing zeros?</P> Tue, 02 May 2023 18:58:57 GMT https://forums.autodesk.com/t5/autocad-forum/table-cell-references-and-calculations-default-whole-numbers/m-p/11937095#M37132 brad_wojcik 2023-05-02T18:58:57Z https://forums.autodesk.com/t5/autocad-forum/table-cell-references-and-calculations-default-whole-numbers/m-p/11937282#M37133 <P><EM>"...when referencing cells from other tables within the drawing.."</EM></P><P>&nbsp;</P><P>Just a thought: Are any of the referenced cells from the other tables that are involved in the calculations formatted as "whole number"?</P> Tue, 02 May 2023 20:33:55 GMT https://forums.autodesk.com/t5/autocad-forum/table-cell-references-and-calculations-default-whole-numbers/m-p/11937282#M37133 dmfrazier 2023-05-02T20:33:55Z