Issue with Table Formulas and the Architectural Unit Styles

[Anonymous]

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

[john.vellek]

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.

[Anonymous]

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

[john.vellek]

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.

[Anonymous]

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

[john.vellek · Accepted solution]

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.

[Anonymous]

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