Adding Attribute In Data Extraction

[christianbaileypaulsen1]

I have a block named "Block", and that block is a attribute named "quantity". When i try to data extract it i select the block as the object to extract, and then quantity as the attribute to extract. Id like to have a total number of how many of that block that i need. I can get a count of how many of that object there are, but it doesn't take into account the quantity entered for each block. So if i had that block in my drawing in three places. The first would have a quantity of one, the second a quantity of 2, and the third a quantity of 3. The total number would be 6, but in my data extraction in only counts that there are 3 instances of that block and returns with count=3. Is there a way to fix this or an alternate version to make it work as planned? Thank you.

[MMcCall402]

I would expect that you would see a list/table by the time you get to page 5 of 8 in the process showing a row for each of the 3 blocks in the example and a column for the unique 'quantity' for each.  At that point you would add a new formula column for sub-total counts of each row and then a total formula at the bottom.

Early in the process you're choosing the entire drawing and not selecting the blocks individually?

I'm not an expert in this process but have set it up and use it every other week or so for counting parking spaces on our site plans using a dynamic that counts the spaces in each row, then the data extraction harvests those values and tables them for a total count.   (last project exceeded 2200!)

[christianbaileypaulsen1]

What would my formula look like? Ive never really done custom formulas in autocad. Im really good with excel if its anything like that. Its just easier with excel because every cell has a letter and number to reference it. Thank you in advance.

[MMcCall402]

The your formula would be <COUNT>*<QUANTITY>  This will make a total for the row by multiplying the quantity attribute by how many blocks have that same quantity attribute value.

Now right click on the header for this column and select "Insert Totals Footer" and then "Sum"  This will make a total for the column.

[christianbaileypaulsen1]

So now it does show the correct total value. Its just not shown in the way id like it to. I dont mean to be picky i just think there has to be a way to make it happen. Ideally it would just be one row, with two columns. The first row being the UTILITY, the second being the TOTAL. 

[MMcCall402]

I'm not yet aware of a way to combine rows.

You could make a regular table and link a cell to the the cell with the total count in this data extracted table.  The downfall is when the the data extracted table updates with more or less rows the linked cell needs to be updated to the new location of the total.

[ToanDN]

Shouldn't the table look like below?

[MMcCall402]

In the pic, the column for the "Quantity" attribute is hidden. As this value changes from block to block it makes a unique row for each of the unique values and only combines rows then the value is the same.

[ToanDN]

So you just entered the value manually for the Quantity field instead of copy or array the block to get the actual count?

[MMcCall402]

I don't know about the inner workings of the OP's block.

In my use for site parking tabulation the block for banks of parking has an attribute that gets its value from a linear parameter within the dynamic block. The block attribute displays the value for labeling on the plan and provides a means of gathering all those values into a table for generating a total for the site.

[christianbaileypaulsen1]

Ill post the block so you can mess with it if you want. We use use it to mark which utilities are going where, and how many are in that one location.

[christianbaileypaulsen1]

Did you happen to get a chance to mess with the block?

[ToanDN]

@christianbaileypaulsen1

I did take a look at the block and since the Quantity field is an attribute, not the actual Count, then what you have is the best outcome that I can think of.