Jump to content
  • 0

division is not working in vectorworks worksheet


Rishie

Question

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. :-(

 

Quote

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:
http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Database_Row_Sort_and_Summary_Functions.htm#XREF_81806_Database_Row_Sort

 

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.

Guest
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...