AutoCAD architecture 2014 - Formula column totals in schedule

[alexandra.arh]

Hi, when creating a schedule with a simple formula column (e.g : [QUANTITY]*Width), the formula column total doesn't add the formula results for a grand total. The total shown is the addition of Width of element.

If I try and enable "Apply formula to totals", the total is : total quantity*total width instead of just a simple addition of formula resulting values.

For example:

I have 4 windows of 2 different styles.Two windows have a width of 2 meters, the other 2 windows have a width of 3 meters. I want to find out, my total window width, of all window styles.Therefore, i make a schedule with the following columns: QUANTITY, WIDTH and TOTAL WIDTH. The total width column is a formula column (Quantity*Width). The total of the formula column (Quantity*Width) doesn't add the resulting values (2*2+3*2=10), it only adds the simple widths without multiplication with quantity, my result is 5, wich is incorect. If i enable "Apply formula to totals", it multiplies total quantity (4) by total width (5).

I need a solution for having the corect total on the formula column.

Thank you,

Alexandra Rus

[pendean]

Why not post a DWG file with the problem for all to test?

[alexandra.arh]

Hello again,

I attached the DWG file with the problem schedule.

Thank you for your reply.

[alexandra.arh]

Hello,

I think i figured out what the problem is.

My WIDTH column TOTAL is already multiplied by the quantity.

I'm sorry for the missunderstanding.

Thank you again,

Alexandra Rus