Jump to content
  • 0

division is not working in vectorworks worksheet



Hello guys,

I tried to calculate average area in worksheet where i need to divide cell B2 by cell C2,

I used (=B2/C2) in cell D2 which is in my database but the result is not as expected, its not actually dividing its just showing the values in Column B.

whereas addition and subtraction is working fine but not divide and multiplication. 

Does anyone have a solution for it,

attached my file below kindly refer it.2016-12-28.png




worksheet div.vwx

Edited by RJR
Link to comment

7 answers to this question

Recommended Posts

  • 0

Just got a message back from the Bug I submitted on this. :-(



This appears to be working as designed. 

The provided file, which has a database row with the criteria, =DATABASE((T=RECT)), has a summarize operator applied to a single column, A. Columns other than A display the sum of each columns subrows. If an additional summarize operator is added to another column, that column will also be summarized to show a single value rather than the sum of the values.

Removing all summarize operators shows that the specified database row cell formulas then work as expected.

The forum user is expecting that the displayed summarized values will be used in calculation with non-summarized values, which is not the case. This behavior, using summarized values, cannot be changed.

Online help documentation:


So If you add additional SUM icons to the other columns you might be able to get closer to what you want.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...