[Calculations in Database sub-rows when summarized.]

9 hours ago, 5600KDesigns said:

Pat, that may very well be the same issue I am looking at here. As the reply from VW said, when I don't summarize a column, the math works as expected.

 

If possible I still think this should be reported as a feature request or bug because as michaelk pointed out, the math works when using a spreadsheet and not database row.

 

In the meantime I did a workaround to get the worksheet to display correct numbers. As the VW training guy had shown in his example to me I took the Roundup function to the nearest tenth and then added 1. E.x. '=ROUNDUP((D2*0.2)+1, 1)' This did give me such things as 13.2 motors, but that is remedied by changing how that column displays and changing it from "General" to "Decimal" and then going to 0 decimal places.

It's still not working quite right because of the Roundup function issue, but it is at least closer to what I am looking for.

MotorPullSheet_Example_PartialFix.vwx

[Calculations in Database sub-rows when summarized.]

On 1/14/2022 at 12:46 PM, Pat Stanford said:

I found the bug report and the response (Working as Designed) the last time I fought an issue like this. I'm not sure if this is the issue we are fighting here or not.

 

Bug Report

 

 

Reply from VW

 

Pat, that may very well be the same issue I am looking at here. As the reply from VW said, when I don't summarize a column, the math works as expected.

 

If possible I still think this should be reported as a feature request or bug because as michaelk pointed out, the math works when using a spreadsheet and not database row.

 

In the meantime I did a workaround to get the worksheet to display correct numbers. As the VW training guy had shown in his example to me I took the Roundup function to the nearest tenth and then added 1. E.x. '=ROUNDUP((D2*0.2)+1, 1)' This did give me such things as 13.2 motors, but that is remedied by changing how that column displays and changing it from "General" to "Decimal" and then going to 0 decimal places.

[Calculations in Database sub-rows when summarized.]

On 1/14/2022 at 10:50 AM, michaelk said:

If you don't use a database it works as expected.  

 

Hmmmmmmm.

 

 

MotorPullSheet_Example_1.vwx 3.32 MB · 2 downloads

Yeah on my template file I had been able to get the '=ROUNDUP' function to work and even have it round to the nearest whole number when not using a database row. For that particular sheet I was generating a pull sheet for a rigging package and had known item types that would not change based on the drawings.

 

Unfortunately that defeats the purpose of what I am trying to do with making dynamic drawing based worksheets for my template file.

[Calculations in Database sub-rows when summarized.]

8 hours ago, michaelk said:

I night not be understanding exactly what you are trying to do.

 

Can you post a file with a worksheet and enough objects to be an example?

Yeah no worries, here's an example of what I am trying to do.

 

I did email with someone from Vectorworks Training and they did get it to work sort of. The difference between what I have here and what they sent me is they set the Roundup function to go to one decimal place instead of the nearest whole number. Their equation is in Column F while mine is in Column E on the worksheet.

MotorPullSheet_Example.vwx

[Worksheet - Sub-total or Group Items]

I’m having a similar if not the same issue in Worksheets and Spotlight. 

[Calculations in Database sub-rows when summarized.]

4 hours ago, michaelk said:

Worksheets will definitely do that.  In column E and F:  make sure that you have those columns set to Sum Values.

Hey,

 

Thanks for the quick reply. I did just try that this morning and it still is doing the wrong math. It seems that it is doing the math on the original sub rows before doing the summarization in Column A. I may very well be doing something wrong, but I am not sure where. I have attached screen shots of the sheet as of this morning along with the formulas I am using. If I export to Excel I can get it to work as I want it to, but I am trying to eliminate that step and use Vectorworks without Excel.

[Calculations in Database sub-rows when summarized.]

Recently I have been working on building a template file for my drafting work in Spotlight. I feel like I have stumbled into an issue with the limitations with the built in Worksheet functionality of Spotlight and possibly the base Fundamentals as well. Basically what I am trying to do is pull information from the databases into the worksheet, summarize and count by Symbol, Cable Length & Type, etc. I then would like to use the count function to get a total of that particular item so I can do some math with it to calculate the spare and total counts  for my pull sheets.

 

What I have found is that the worksheets don't work this way when using the database row/sub-rows in 2022 SP2.1. For example, on my Hoist Pull Sheet worksheet, when I summarize the symbols listed in A2 and then do an =COUNT in D2 I get the proper count of the hoists in the drawing. In E2 I do the function =ROUNDUP((D2*0.2), 0) but it only calculates to 1, no matter if I have 1 or 15 as the count in a sub row of D2. in F2 I did a =SUM(D2, E2) and I somehow got it to say 11 + 1 equals 2.

 

What I am hoping to see in a future service pack update is for worksheets to recognize when a database row and it's sub-rows have been summarized by a column and to allow math to be done in columns following a summarized entry as if it is a spreadsheet. I know some may suggest that I export my worksheets to Excel, but I feel like that defeats the purpose of what I am trying to do with this template file and making my paperwork generation quick, easy and having a consistent look for my vendors and clients.