VBScript sorting items in Schedule Table

[Anonymous]

I've put together a schedule table that does almost everything I want it to to, but I can't get through this last hurdle.

The table takes the timber panels and organises them by name.  Shows panel height and length and then shows a width matrix.  

I'm trying to have three sorted columns working out total panel length sorted by panel width.  I've tried every if/then elseif/else I can see, but always end up with just code displayed in the total boxes.  Please help.

I've included the dwg of the schedule, but because some of the property set definitions don't come from AutoCAD objects, the file won't show the wallobjects.  

Good luck!

[David_W_Koch · Accepted solution]

Welcome to the community!

Your formula columns simply put the WallObjects:Length property in for each one.  I assume what you want is for the length to show up in the formula column that matches the Width value.  Without a file with the objects I cannot test the following, but setting up an If...Then...Else block that tests against the WallObjects:Width value and, if it matches that columns target width, sets the RESULT to WallObjects:Length and, if it does not, sets it to 0 should do what you want.

In the image below, I show what you need for the Total 89 column.  For the Total 140 and Total 300 columns, substitute 140 and 300, respectively, for 89 in the first line of the formula.

Be certain to add the [WallObjects:Width] and [WallObjects:Length] property references by selecting them from the Insert Property Definitions area at the lower left of the dialog; just typing them in will not work.  They should have a light gray background in the dialog.

[David_W_Koch]

@Anonymous 

I set up a quick test file, using Standard Walls to stand in for the Panels, and the formulas work as expected.  See attached DWG and the image below.