topic Re: Issue with Table Formulas and the Architectural Unit Styles in AutoCAD Forum

Issue with Table Formulas and the Architectural Unit Styles

Anonymous — Mon, 23 Apr 2018 14:06:28 GMT

I've got a table I'm using to automate cutlists for some standard assemblies. I have all of my units styles set to architectural. When I try to use architectural units with a subtraction formula, it uses addition instead. If I change the source cell (the cell the formula references) to Decimal units it works fine. I've also noticed this only occurs when the source cell is a whole foot measurement. cells formulaSource cell (C3) in architectural units, the formula is incorrectSource cell (C3) is in decimal units, formula cell is correct

Re: Issue with Table Formulas and the Architectural Unit Styles

john.vellek — Mon, 23 Apr 2018 14:18:16 GMT

HI @Anonymous,

Can you share a sample table with this data? Which version of AutoCAD are you using?

I would like to test this and see if I can give you an answer or log it for the development team to investigate.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Issue with Table Formulas and the Architectural Unit Styles

Anonymous — Mon, 23 Apr 2018 14:22:00 GMT

See attached for DWG with the table. This was created in Autocad 2018.

Re: Issue with Table Formulas and the Architectural Unit Styles

john.vellek — Mon, 23 Apr 2018 14:55:01 GMT

Hi @Anonymous,

I have been playing with your table for a bit. Thanks for the file. I see the math doesn't necessarily update if the cell being referenced has the format changed. I went from decimal to architectural and I don't think the math changes. If I clear the cell, enter the value in Architectural units, then the math works properly. Can you try this too?

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Issue with Table Formulas and the Architectural Unit Styles

Anonymous — Mon, 23 Apr 2018 15:10:29 GMT

John -

Thanks for the prompt reply. I tried clearing the cell and inputting the value in architectural units, the math error still exists. If I input 4'-1" the math works fine, but a whole foot increment causes the formula to add rather than subtract. See attached screencast

Re: Issue with Table Formulas and the Architectural Unit Styles

john.vellek — Mon, 23 Apr 2018 16:23:48 GMT

Hi @Anonymous,

I found that putting the value to be subtracted into parenthesis, this functions properly for me.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Issue with Table Formulas and the Architectural Unit Styles

Anonymous — Mon, 23 Apr 2018 16:27:54 GMT

That looks like it did the trick, thanks for the help!